September 26, 2007 at 10:05 am
Hi Friends,
I have a secondary server DB which is in Norecovery mode at present my primary Server is problem i want to bring into back my secodary server into primary with DB as an Recovery mode.
If any one having any idea how to bring my NoRecovery mode DB into Recovery mode
Please Help me it is very ugent.
Kishore KK
September 26, 2007 at 1:38 pm
Assuming no active mirroring or replication jobs and assuming I understand your question, I believe issuing:
RESTORE DATABASE MyNwind WITH RECOVERY
GO
should do it. (Replacing MyNwind with the name of your database.)
September 27, 2007 at 5:56 am
But I don't have any .BAK files at now. I have only the Secondary server DB which in the mode of norecovery.
Kishore KK
September 27, 2007 at 11:11 am
Well first of all you should really figure out *why* it's in norecovery.
Second, look at the command I gave you. There's no ".bak" file mentioned nor needed.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply