Log Shipping

By Nigel Rivett on 23 January 2005 | 0 Comments | 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."
Follow the link to Log Shipping...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

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

Other Recent Forum Posts

eat scrumptious caffeine using these guidelines (0 Replies)

eat scrumptious caffeine using these guidelines (0 Replies)

eat scrumptious caffeine using these guidelines (0 Replies)

?????? ??????????? ?????? 2017 (0 Replies)

WITH EXECUTE_AS not working for sproc. (9 Replies)

Data loss during sql cluster failover (3 Replies)

How to make Ajax Accordian Visible based on dropdo (2 Replies)

Corrupt SMALL transaction log backups in Log Shipp (3 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -