Select the state for the database after the restore.

• Recover

  Restore the last image in a restore sequence and make the database ready for use.

• Restoring

  Restore an intermediate backup image. The database is left in a loading state so you can restore and apply additional backup images.

• Standby

  Create and maintain a standby during a transaction log and database restore. This option requires a standby undo log, which by default is placed in the same directory as the primary datafile. The account that runs the SQL Server service must have full access permission to the SQLStandBy folder.

The consistency check to perform after the restore. Output from the consistency check is written to the SQL Server client progress log.

• Do not perform

  Do not perform consistency checking.

• Full check, including indexes

  Include indexes in the consistency check. Any errors are logged.

• Full check, excluding indexes

  Exclude indexes from the consistency check. If indexes are not checked, the consistency check runs significantly faster but is not as thorough. Only the data pages and clustered index pages for each user table are included in the consistency check. The consistency of the non-clustered index pages is not checked.

• Check catalog

  Check for consistency in and between system tables in the specified database.

• Physical check only

  Perform a low overhead check of the physical consistency of the SQL Server database. This option only verifies the integrity of the physical structure of the page and the record headers. It also verifies the consistency between the pages' object ID and index ID and the allocation structures.