Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Target tab of the Restore Policy Wizard allows you to specify the database that you want to keep updated with routine restores.

...

If your instance is not displayed in the SQL Server drop-down list, you can choose to add a new instance by clicking the Register SQL Server button. For more information, see Register register an instance.

How do you change the location of your database files?

...

How do you set the restore schedule?

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

...

You can instruct SQL Safe to disconnect users from the database before performing the restore. To do so, select the Disconnect usersusers option from the restore options.

What other additional options do you have?

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

  • DB Owner - Specify the database owner.
  • 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 use the Microsoft SQL Server Change Data Capture (CDC) feature.
  • Pre/Post-Backup Commands - allows you to specify commands you want to execute before and/or after the backup completes. Select Configure.. to determine the commands you want to run. Click on Image Added to add the cmd file. You can also select to Quit the backup job if the pre-backup command fails. Yes is the default.
    The command can be a script or a user executable, non-interactive program. It should be located on a UNC path.

Once you select the target database, click NEXT to configure notifications.



SQL Safe Backup hands-free backup and instant recovery across your SQL Servers.
Scroll pdf ignore
Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse