Post reply

convert DB from NoRecovery Mode to Recovery Mode?

  • September 26, 2007 at 10:05 am

    #125856

    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

    #736517

    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

    #736684

    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

    #736866

    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