Backing Up a Restoring Database

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738112

  More actions

  September 29, 2023 at 12:00 am

  #4259023

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

• Thomas Franz

  Hall of Fame

  Points: 3927

  More actions

  September 29, 2023 at 8:33 am

  #4297501

  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.