Scheduling restores: configure restore options

Scheduling restores > Select destination server and backups to restore > Select destination database > Specify file locations > Specify verification options > Configure restore options > Create restore schedule > Review summary

This topic describes the Schedule Restore Jobs wizard page for configuring the settings to be used on restore.

Recovery completion state

Select the state in which you want the database to be left on completion of the restore operation.

• Operational

  The database is restored from the backup, and recovery is completed. Incomplete transactions are rolled back. The database is fully usable. Additional transaction logs or differential backups cannot be restored. This is equivalent to using the SQL Server RESTORE WITH RECOVERY option.

• Non-operational

  The database is restored but not recovered. Incomplete transactions are not rolled back. The database is not usable, but differential backups and transaction log backups can be restored to it. This is equivalent to using the SQL Server RESTORE WITH NORECOVERY option.

  This option is not available if you have selected Run database integrity check following restore on step 4 of the wizard.

• Read only

  The database is restored and recovered. Incomplete transactions are rolled back, but recorded in the Undo file. The data in the database can be read, but not modified. Differential backups and transaction log backups can be restored to it. This is equivalent to using the SQL Server RESTORE WITH STANDBY option.

  To change the location of the Undo file, in the Undo file box, type the full path on the standby server for the file, or click and specify the file using the File Browser. For information about how to specify file names on remote servers, see Specifying file paths.

Checking for orphaned users

If you are restoring a database onto a different SQL Server instance, it is possible that some of the restored database user accounts will not have an associated server login on that instance. These database user accounts are known as orphaned users, and will be unable to provide access to the database unless you create their associated logins.

Select Check for orphaned users and list in log file to run a check for orphaned users when the restore job has completed. If any orphaned users are found, a warning is included in the SQL Backup log file, along with a list of the orphaned users.

This option is not available if any of the following are true:

• Drop database following restore is selected
• The recovery completion state is set to non-operational
• You are restoring a filegroup backup

SQL Backup does not fix orphaned users automatically. If orphaned users are reported, you should consider creating the required logins on the SQL Server instance that you are restoring to.

For more information about database user accounts, logins, and fixing orphaned users, refer to your SQL Server documentation.

Email notification

If you want to receive an email with a copy of the completion log, select Send email notification and enter the recipient's email address. This option is available only if you have entered your email settings in the Server Options. For more information about setting up email notification, see Email notification options.

To send the log to multiple email addresses, type each address separated with a semi-colon (;). For example:

dba01@myco.com;dba02@myco.com

• By default, email notifications are sent only when there are errors during the restore process (Error only).
• If you want to receive an email when either an error or warning occurs, select Error or warning.
• To always receive an email on completion of the restore process (on success or failure), select Any outcome.

Next: create restore schedule