Post reply

Putting a database in recovery mode

  • December 5, 2006 at 5:45 pm

    #61733

    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.

  • December 5, 2006 at 6:34 pm

    #676109

    You'll have to restore your full backup again to do this.

    This time, specify WITH REPLACE, NORECOVERY.

    Ronald San Juan | SQL DBA
    ID 710124 ~ Code "Northwind"

  • December 5, 2006 at 9:02 pm

    #676123

    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

  • December 6, 2006 at 12:16 am

    #676141

    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 ,

    Shekhar

  • December 7, 2006 at 2:30 pm

    #676745

    Thanks everyone.

Viewing 5 posts - 1 through 4 (of 4 total)

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