Restoring Backups
This topic describes the Restore wizard page for configuring the settings to be used when you restore the backups.
Recovery completion state
Select the state in which you want the database to be left on completion of the restore operation.
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.
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.
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 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.
Transaction log
If you are restoring transaction logs, you can specify the exact time to which you want to restore the transactions. Select the Restore transaction log to point in time check box, and select a transaction log from the list. The slider shows the time period covered by the selected transaction log; move the slider to select the exact time to which you want to restore the transactions.
If you have selected a transaction log backup for which SQL Backup Manager cannot find the preceding backup, SQL Backup Manager cannot determine the start time of the period covered by the transaction log backup. You must therefore type the time and date of the point in time to which you want to restore the backup.
On completion
If you want to receive an email with a copy of the completion log, select the Send email notification check box, and enter the 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:
address1@mail.com;address2@mail.com
If you want to receive an email only if an error occurs during the restore process, select Send on failure only.
| 
