Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Log Shipping

By Nigel Rivett on 23 January 2005 | Tags: Transaction Logs

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."

Link: Log Shipping

Related Articles

Dealing with a large transaction log file (19 June 2004)

Other Recent Forum Posts

SQL HELP in SSMS: The query references an object that is not supported in distributed processing mode (4d)

Subscription sends report with data to one user but empty report to other users (7d)

Pivot Tables in SQL (14d)

Can't restore backup; SSMS says my user account directory is empty (14d)

REPL55012 error (40d)

SQL 2022 SSIS does not write data in Excel (48d)

SUBSTRING Functions (53d)

SQL - Purchase Order and Invoice duplicate amount (58d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources