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

 
 

About the author

 
 
 
sitemap

Unable to load book!

The book could not be loaded.

(try again in a couple of minutes)

manning.com homepage
test yourself with a liveTest