March 1, 2006 at 8:25 am
Hi everybody,
We have a DR site about 1000km away from our primary site, so full backups of databases can't be shipped on WAN (size @ 13gb). Hence I want to take backup on standby server. We have configured log shipping. Is it possible to stop log shipping for some time, open standby database in normal mode, take a backup, again make it standby & start log shipping. Please advice on the situation.
March 1, 2006 at 9:23 am
My understanding is that you can't do that. Once you put the database in 'normal mode', that recovers it and no more transaction logs can be applied. It is now a 'live' database.
I believe the same might be true if you detach the database, backup the .mdf/.ldf files, and attach the database.
-SQLBill
March 1, 2006 at 11:30 am
You're a perfect candidate for a backup compression utility like LiteSpeed for SQL Server from Quest Software. LiteSpeed compresses your database backup files by 75-95% so they can be written to network devices even through a low speed WAN. For more information either send me a message or go to http://www.quest.com/litespeed
March 2, 2006 at 11:48 am
I can confirm that changing the standby database back to normal mode will definitely break log shipping. I've tried it 🙂 You'd have to set up log shipping again from scratch.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply