Rating: No reviews yet
Downloads: 150
Released: Jul 30, 2015
Updated: Jul 30, 2015 by MicahNikkel
Dev status: Stable Help Icon

Recommended Download

Source Code Streamline_LS_Failovers.sql
source code, 88K, uploaded Jul 30, 2015 - 150 downloads

Release Notes

SQL script that dynamically generates a set of scripts that can be used to systematically fail over all log-shipped databases from the Primary to the Secondary (and back again if desired). Scripts 01.sql - 05.sql fail over to the Secondary and 06.sql - 10.sql fail back to the Primary, carrying over any changes that may have been made on the Secondary. If the Primary is unavailable, a variable can be changed to simply bring up the Secondary after applying all available logs.

Reviews for this release

No reviews yet for this release.