The Target tab of the Restore Policy wizard Wizard allows you to specify the server, database name, and restore schedule for your new database.
You can perform the following actions:
- Select the SQL Server instance where your target database is.
- Select the database you want to update or create a new one.
- Specify the location of the data and log files of the restored database. SQL Safe displays each database file (by logical name) and the directory where each will be restored.
- Choose the appropriate recovery state for the database (Fully Accessible, Accessible but read-only, or Not Accessible).
- Schedule when the Agent should execute the restore job.
- Select other restore options.
...
- Ignore checksum errors - Select this option to ignore any errors from the generated checksum. If checksum errors are encountered, this option indicates that SQL Safe should continue to back up this database.
- Preserve replication settings - Choose this option to retain the settings used when the selected databases were replicated.
- Keep CDC - choose this option to restore databases that uses Microsoft SQL Server Change Data Capture (CDC) feature.
Once you select the target database, click NEXT to configure After defining your setting in this tab, click Next to configure your notifications.