Page History

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.

How do you change the location of your database files?

...

You can recover SQL logins associated with this database by selecting the Restore database logins optionoption. You can use this option when the source backup files contain login information. To capture login information, configure your backup policy to include the database logins.

What do you do if you have users connected to the database?

You can instruct SQL Safe to disconnect users from the database before performing the restore. To do so, select the Disconnect users option option from the 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.

After defining your setting in this tab, click Next to configure your notifications.  

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

...

• 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 notifications.

...