Can anyone explain the main differences?

Any help appreciated.

| improve this question | | | | |
  • 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.


| improve this answer | | | | |
  • 3
    thanks, the blog is very good! Shame on me. Google would have answered the question too. – muffls Jan 3 '13 at 12:18

There is more to it. A database restore issued with NORECOVERY is left in a pending state and cannot be accessed. Logs and differentials can be added to the database while it is in this state since no independent activity is occurring on it.

RECOVERY places the database in an operational state. You cannot add any more components of a backup set to it at this time.

| improve this answer | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.