Online Documentation for SQL Administrator for SQL Server

Setting restore options

This step offers some additional options that are specific for each restoration mode.

Restore options

Confirmation before restoring each backup

If this option is selected, the program requires confirmation each time you run the process of restoring a database.

Restrict access for the database to db_owner, dbcreator or sysadmin

This option restricts access to the newly restored database to members of the db_owner, dbcreator, or sysadmin roles.

Keep replication settings of the restored database

This option specifies that the replication settings are preserved upon restoration of a published database to a server other than that on which it was created. It prevents replication settings from being removed when a database or log backup is restored on a warm standby server and the database is recovered.

Media checking options

Perform checksum verification before writing to media

This option enables/disables checksum verification before restoring from the backup media.

Continue on checksum errors

This option determines whether the restore operation will be stopped or forced to continue if an error occurs.

Click the Next button to proceed to the Setting recovery options step of the wizard.