September 10, 2009 at 2:41 pm
what is the difference between recovery and norecovery while doing restore.
September 10, 2009 at 2:44 pm
BOL
recovery bring database online while norecovery leave it for further log resotred
:crazy: :alien:
Umar Iqbal
September 10, 2009 at 7:54 pm
The difference between RECOVERY and NORECOVERY is, briefly, that RECOVERY rolls back any uncommitted changes (this is called UNDO). This makes the database consistent again so it can be safely brought online. NORECOVERY skips the UNDO phase so uncommitted or incomplete transactions are held open. This allows further restore stages to carry on from the restore point.
There's too much detail for one general reply, so have a read of this: Understanding How Restore and Recovery of Backups Work In SQL Server
Post back if you have any detailed questions not answerable from that resource and its links 🙂
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 11, 2009 at 1:29 am
RECOVERY stands here for database is recovered from sinle/multiple backup files after applying them sequencially. The database is ready to use for any further actions.
NORECOVERY stands here for database is still in the process of recovery and waiting for more backup files (diffrential or transaction log backup files) to be applied on the database to complete the recovery process. The database is yet not ready to use by any user/application.
RECOVERY is the last option statement in the process of database restoration from multiple backup files to bring the database online.
September 12, 2009 at 1:14 am
Paul White (9/10/2009)
The difference between RECOVERY and NORECOVERY is, briefly, that RECOVERY rolls back any uncommitted changes (this is called UNDO).
Does it not roll forward all the committed changes, is it not in the same phase?
September 12, 2009 at 7:08 am
Krishna (9/12/2009)
Paul White (9/10/2009)
The difference between RECOVERY and NORECOVERY is, briefly, that RECOVERY rolls back any uncommitted changes (this is called UNDO).Does it not roll forward all the committed changes, is it not in the same phase?
Yes, this is REDO. The details are in the link I provided before.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply