Log shipping: restore settings

Log shipping > Specify databases > Backup settings > Network share > Restore settings > 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 specified in step 3) to another folder, 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 folder browser. Note that this folder should not be the same location as the network share specified in step 3.

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

Select the Delete existing backup files in this folder for the selected databases check box if you want SQL Backup to delete existing backup files for the selected database in the specified folder. You can restrict deletion of existing backup files by age or number. To restrict deletion of files by age, select All files older than and type or select the age (in days or hours) of the files that you want to delete. To restrict deletion of files by number, select All files except the latest and type or select the number of the latest backup files to keep.

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

Next: set the schedule