Project Description

SQL file that dynamically generates the scripts needed for failing over (and back if desired) all Log Shipped databases. Helping streamline even a single database failover/back, it's most useful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc. This solution provides a systematic way to perform DR tests, fail over in an emergency, or migrate to a new database server.

For helpful articles relating to this solution, please visit the following links:

Published in 2015:
SQLServerCentral.png
http://www.sqlservercentral.com/articles/Log+Shipping/130316

Published in 2014:
CodeProject.png
http://www.codeproject.com/Tips/807845/Streamline-Log-Shipping-Failovers

Published in 2013:
SQLServerCentral.png
http://www.sqlservercentral.com/articles/Log+Shipping/104391

NOTE: Click the DOWNLOADS tab above to sign up for notifications of new code releases.

Last edited Oct 20, 2015 at 6:07 PM by MicahNikkel, version 26