Putting a database in recovery mode
-
Hi everyone, I restored a full backup of a database today and apparently the data that we need is not in the restored database. So now I have to apply some logs, how can I put the database into recovery mode again so that I can apply these logs? Thanks in advance for your help.
-
You'll have to restore your full backup again to do this.
This time, specify WITH REPLACE, NORECOVERY.
-
Unfortunately once you recover the database you can't do any more restores. As Ronald says, you will have to start over. Remember to use that WITH NORECOVERY until you have applied you last restore. Then use WITH RECOVERY. If you forget and your database is marked LOADING, just run this:
RESTORE DATABASE bname WITH RECOVERY
-SQLBill
-
yes.. once we restore the database we cannot restore any logs unless we use WITH STANDBY option in RESTORE statement
or
we specify the "Leave database readonly and able to restre additional logs" option in database restore winzard
In both the cases the database remains READONLY unless we restore a Log using WITH RECOVERY .....
-
Thanks everyone.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply