mhenriks
SSC Eights!
Points: 969
More actions
May 16, 2002 at 8:16 am
#57969
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!
Andy Warren
SSC Guru
Points: 119902
May 16, 2002 at 8:50 am
#429272
Try this:
RESTORE DATABASE MyNwind
WITH RECOVERY
Andy
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
May 16, 2002 at 9:17 am
#429275
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
#429279
Think you have to put it back in standby.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply