THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Linchi Shea

Checking out SQL Server via empirical data points

Scripting out the log shipping setup

If you use SQL Server Management Studio to generate a script on an existing native log shipping setup, you need to be careful when using that generated script. Other than the fact that it lumps the SQL statements for different servers into the same script file, you may want to know that the copy and restore job schedules are not truthfully captured in the script. In fact, the schedules are not captured at all. The script simply chooses a default schedule regardless what your actual copy/restore schedules may be.

 You may already know this, but I learned the hard way.

Published Tuesday, November 16, 2010 9:28 AM by Linchi Shea
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Derek Wharton said:

Thank you for the info!

November 16, 2010 9:33 PM

Leave a Comment

(required) 
(required) 
Submit

About Linchi Shea

Checking out SQL Server via empirical data points

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement