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.

Creating the T-SQL script

Creating a cleanup script

Creating a batch file

Improving the log shipping process

Summary