Post reply

Restore "Norecovery" Mode

  • November 17, 2011 at 12:25 pm

    #246260

    I recently restored a full backup of a database. I put the database in "norecovery" mode so that when it finished no users would be able to access it until I wanted them too.

    What command will take a database that is in "norecovery" mode to online and available? Do you simply run the restore command with the the parameter pointing to the disk file and give it a "with recovery" option?

  • November 17, 2011 at 12:48 pm

    #1409473

    Try this.. restore database DBName with recovery

  • November 17, 2011 at 1:10 pm

    #1409488

    That is what I was thinking. I will try it once the restore finishes.

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

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