Chapter 35. The poor man’s SQL Server log shipping

Edwin Sarmiento

Let’s imagine that you’ve got a new line of business application up and running smoothly. You’re extending your disaster recovery plan to include this new application. For database, you’re thinking along the lines of log shipping until you read the documentation provided by the vendor: The installation program installs SQL Server 2005 Express Edition.

Log shipping is a high availability solution of SQL Server, in which the SQL Server Agent automates the process of generating transaction log backups of the source database, copying them over to a remote SQL Server instance, and restoring them in either no-recovery or read-only, standby mode. It has gained popularity as a high ...

Get SQL Server MVP Deep Dives now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.