Post reply

Change existing database mode??

  • November 14, 2007 at 7:31 am

    #179335

    Hi Experts,

    I have restored a database as normal and wish to know if I can change it to be in STANDBY or NO RECOVERY mode without having to restore it again into that mode.

    Is there a way to change it if it already exists? I want to use it as a secondary db in a log shipping procedure.

    Thanks,

  • November 15, 2007 at 7:07 am

    #751495

    You can change to read only mode but not to stand by or recovery mode after a full restoration.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • November 19, 2007 at 7:38 am

    #752282

    You have to re-run the restore and use the WITH NORECOVERY or STANDBY options during the restore.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply