Log Shipping: Restore Settings

Log Shipping > Specify Databases > Backup Settings > Restore Settings > Network Share > Schedule > Review Summary

This topic describes the wizard page for specifying your settings for restoring the transaction log backups.

Destination database restore options

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

Non-operational
The database is restored but not recovered. Incomplete transactions are not rolled back. The database is not usable, but transaction log backups can be restored to it. This is equivalent to using the SQL Server RESTORE WITH NORECOVERY option.
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. 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.

On completion

When they have been restored, SQL Backup moves the transaction log backup files from the network share (which you specify in the next step), so that they are not processed in the next run. Specify the path for the folder to which the processed transaction log backup files are to be moved.

SQL Backup displays a default path for the files. To change the path, type the full path for the folder, or click and specify the folder using the file browser.

For information about how to specify file names on remote servers, see Specifying File Paths.

Select the Delete existing transaction log backup files in this folder for this database check box if you want SQL Backup to delete existing backup files for the selected database in the specified folder, and type or select the age (in days or hours) of the files that you want to delete.

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. 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 or warnings during the restore process. If you want to receive an email only if an error occurs, select Error only; to always receive an email on completion of the restore process (on success or failure), select Any outcome.