Post reply

Setting the database in recovery mode

  • September 6, 2007 at 6:09 am

    #176385

    Hello,

     

    Can anybody tell me how to set a online database in recovery mode? When that is possible i can restore the logs!

     

    Thanks

  • September 6, 2007 at 9:08 am

    #731886

    Hi,

    You can't put a database in recovery status before restoring a backup.  You should restore the full backup using WITH NORECOVERY so uncommitted transactions are not rolled back.  Then restore all  log backups except the last one using WITH NORECOVERY.  The last log backup is restored using WITH RECOVERY.  See 'Restore scenarios' in BooksOnLine for examples.

    Greg

    Greg

Viewing 2 posts - 1 through 2 (of 2 total)

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