May 16, 2002 at 8:16 am
We have lost some data in our priamry production db, I am log shipping to a backup server but the backup db is marked "loading". I need to get to this data now!
Help!
May 16, 2002 at 8:50 am
Try this:
RESTORE DATABASE MyNwind
WITH RECOVERY
Andy
May 16, 2002 at 9:17 am
Thanks a bunch Andy! that worked.
Should I change the recovery mode of the backup db now so the log shipping restores will work again?
May 16, 2002 at 9:47 am
Think you have to put it back in standby.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply