Backing Up a Restoring Database

  • Comments posted to this topic are about the item Backing Up a Restoring Database

  • take the database offline (or at least ensure, that nobody writes to it by executing another RESTORE DATABASE on it) and make a file copy / backup of it and attach it on another server  or with an different name as "restore". The restored database would be in the NORECOVERY state too.

    And don't forget to set the original one to online again.

    God is real, unless declared integer.

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

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