SQLTeam.com Logo

Return to Log Shipping

Log Shipping

Written by Nigel Rivett on 23 January 2005

nr submitted "yet another log shipping process.
Uses an SP on the sourcer server to backup the database.

Uses two SPs on the destination.
One to synchronise backup folders with the source.
Another to restore the full backup if it exists - moving the data and log files, then restoring the following sequence of log files."