Step 7. Specify Recovery State

At the Recovery State step, select a recovery state for the database:

• Default (RECOVERY)

Rolls back (undo) any uncommitted changes.

• NORECOVERY

Skips the undo phase so that uncommitted or incomplete transactions are held open.

This allows further restore stages to carry on from the restore point. When applying this option, the database will be in a norecovery state and inaccessible to users.

• STANDBY

The database will be in standby state and therefore available for read operations. You can also provide a standby file with uncommitted transactions.

For more information on recovery states, see this Microsoft article.