Restoring Server which utilizes Log Shipping
From: Will Wirtz (WillCWirtz_at_Yahoo.com)
Date: 07/30/04
- Next message: Brian Newtz: "Re: sqlmaint using noinit and noformat"
- Previous message: Stephen Dybing [MSFT]: "Re: Transaction Log getting shrunk automatically"
- Next in thread: Andrew J. Kelly: "Re: Restoring Server which utilizes Log Shipping"
- Reply: Andrew J. Kelly: "Re: Restoring Server which utilizes Log Shipping"
- Messages sorted by: [ date ] [ thread ]
Date: 30 Jul 2004 10:24:55 -0700
I have a large database that gets a full backup every night. We
utilize Log Shipping from this database to another database on a
reporting server. During the day Log Shipping creates log files on
the local server and truncates the transaction log for the database.
Everything works great. Lets say at 2:00pm the database crashes. I
restore the database from the previous nights full backup. Now I want
to restore the transaction log up to 2:00pm. The problem is that it's
empty because the log shipping has truncated it throughout the day.
What I do have is over 1000 small transaction files that were created
for log shipping. How can I apply all 1000 transaction files in the
shortest amount of time? I won't even think about doing each one
seperately.
Will
- Next message: Brian Newtz: "Re: sqlmaint using noinit and noformat"
- Previous message: Stephen Dybing [MSFT]: "Re: Transaction Log getting shrunk automatically"
- Next in thread: Andrew J. Kelly: "Re: Restoring Server which utilizes Log Shipping"
- Reply: Andrew J. Kelly: "Re: Restoring Server which utilizes Log Shipping"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
