Changing Database status from Restoring to Online

• henrymcc

  SSC Veteran

  Points: 205

  More actions

  May 11, 2016 at 3:28 am

  #316445

  Hi.

  I'm busy scripting a daily backup and restore from our production environment to a data recovery server.

  I'm doing 1 weekly full backup and 5 daily differential backups. These files sit on a backup server separate from Prod and DR. In restoring the backup files i want to keep the database in the "Restoring" state until i receive the last differential backup and then change the status to online. I keep it in recovery state by doing a restore "WITH NORECOVERY" and then on the last restore i will do a restore "WITH RECOVERY".

  While my DR is in a restoring state, how would i be able to bring it back online if for some reason i don't have access to the last differential file(s)? Is there a way to do this?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  May 11, 2016 at 3:43 am

  #1878085

  Run

  RESTORE DATABASE <database name> WITH RECOVERY

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass