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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.