By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,163 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

How Do I Restore A Warm Backup If My Primary Server Fails?

P: n/a
In SQL 2000 I have been using Log Shipping to keep a warm backup copy
of all my production databases in a different site. Prior to setting
up my Maintenance Plan to implement log shipping, on my Secondary
server I create the warm backups using the following statement:

RESTORE DATABASE ProdDB FROM DISK = 'E:\Backup\ProdDB\ProdDB.bak'
WITH MOVE 'ProdDB_Data' TO 'E:\DATA\ProdDB.mdf',
MOVE 'ProdDB_Log' TO 'E:\DATA\ProdDB.ldf',
STANDBY = 'E:\Backup\ProdDB\ProdDB_Standby'
GO

This makes the primary and secondary servers start with exactly the
same database. Then I implement my maintenance plan to establish the
log shipping. One of the final steps before completing the maint plan
setup in the maint plan wizard is to set the destination database
Secondary Load State to Standby Mode, and check off "Terminate users in
database (Recommended).

Now its been very long since this plan was set up, the initial
ProdDB.bak file has long been deleted. Only transaction logs exist on
my secondary server.

If my primary server has a catastrophic failure due to a fire, how can
I recover/BACKUP a copy of my warm backup database and RESTORE it to a
new Primary server?

Any help would be greatly appreciated,

Mike

Apr 13 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.