January 10, 2003 at 6:08 pm
Hello -
Windows 2000/SQL Server 2000 Standard
I'm developing a log shipping process for my company in order to keep a warm
standby server up to date on our WAN. The log shipping will ship the logs
twice daily but only a full backup weekly (cannot copy over full databases
in 24 hours over the WAN). I do, however, want to keep my daily full
database tape backup running.
When I run the full backup on tape each day, I believe that resets the logs
so that the next log shipment to the standby server will be out of sequence
because the last full backup over there was not the last full backup on the
production server (tape).
How do I keep the trans logs in sequence, or, perhaps, how do I perform a
full backup but still keep the logs in sequence over on the standby server?
Thank you for any information and/or suggestions.
Sean
January 13, 2003 at 8:00 am
This was removed by the editor as SPAM
January 13, 2003 at 1:47 pm
A full backup restored to the standby server is not needed unless there was some failure there. Just keep appling the next transaction log. Why not increase the frequency of the tran log backup, the overhead is minimal?
You'll still want to do full backups on your production database server and archive them with some GFS scenario. The stand by server however has no need for this backup.
John Zacharkan
John Zacharkan
January 13, 2003 at 2:12 pm
Thanks John. Yes, I will increase the log backups as long as we're not seeing a hit on performance. I've pretty much got a working scenario planned out. The only tricky part now is when to shrink the logs and how to keep the standby server in sequence after that. Probably have to push over another full backup at that point. Thanks again.
Sean
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply