May 11, 2016 at 3:28 am
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?
May 11, 2016 at 3:43 am
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply