The Target tab of the Restore Policy wizard allows you to specify the server, database name, and restore schedule for your new database. 

You can perform the following actions:

How do you change the location of your database files?

If SQL Safe does not display the correct location where you want to restore a file, click  Select in the Database File Locations section and change it to your preferred location.

The Database File Locations window allows you to manage the paths where SQL Safe restores new data and log files. Files names are created automatically, using the file type and destination database for easier identification.

Can you access your files during the restore operation?

To access your files while SQL Safe executes the restore operation, choose from the following options:

How do you set the restore schedule?

You can click Schedule on the Restore Job option and set the frequency and the duration of your restore policy job.

How do you restore the SQL logins for this database?

You can recover SQL logins associated with this database by selecting the Restore database logins option. 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.

When you choose a database file with ".bak" or native format, the option Restore database logins is disabled.

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 from the restore options.

What other additional options do you have?

Additionally, you have the following options when performing your restore:

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 > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResourcesLegal