February 23, 2010 at 8:09 pm
Hi All,
I restore my back up file with NoRecovery option first, Then I restored Recovery option.
NoRecovery : Database can't access, and it will restoring mode.
Recovery: I access the database.
So Internally what will happens in the database engine. Please share with me.
Regards
Subbarayudu
February 23, 2010 at 9:46 pm
From BOL
NORECOVERY specifies that roll back not occur. This allows roll forward to continue with the next statement in the sequence.
In this case, the restore sequence can restore other backups and roll them forward.
RECOVERY (the default) indicates that roll back should be performed after roll forward is completed for the current backup.
Recovering the database requires that the entire set of data being restored (the roll forward set) is consistent with the database. If the roll forward set has not been rolled forward far enough to be consistent with the database and RECOVERY is specified, the Database Engine issues an error.
EnjoY!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply