Browse by Tags

• Automation
• Perl
• Scripting
• SSMS

• 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 Read More... Posted Tuesday, November 16, 2010 9:28 AM by Linchi Shea | 1 Comments Filed under: Log shipping, SSMS

• Get an overview report on your log shipping setups

  [Updated Dec 23 to include a T-SQL script at the bottom of the post]. You may have an environment where log shipping is set up on various databases between various servers. Would it be handy to have an overview report highlighting which database is being Read More... Posted Monday, December 21, 2009 10:45 PM by Linchi Shea | 3 Comments Filed under: Perl, Scripting, Automation, Log shipping Attachment(s): scanForLogshipping.zip