The Target tab of the Restore wizard allows you to you select the SQL Server instance where you want to restore the database(s). In this section you can follow these steps:

  1. Select from the drop-down list the SQL Server instance where you want to restore your database(s). If your instance is not displayed, register it by using the Add Instance Wizard
  2. Choose one of the following actions:
    • Restore - select this option to restore your databases. You can select the option Disconnect users before restore to instruct SQL Safe to disconnect users from databases before performing the restore operation.
    • Verify - this restore option helps you ensure your backup operations are successful without actually restoring your data. Consider using this restore verification option on all critical backups after executing the backup operation.

What other Advanced Options do you have on this section?

You can specify the number of threads for compressing data or you can choose the Auto option so that SQL Safe calculates the optimum number of threads for your operation.

You can also set to run Pre/Post-Restore Commands. Select Configure.. to specify commands you want to execute before and/or after the backup completes. Click on  to add the cmd file. You can also select to Quit 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 instance for your restore, click NEXT to select databases



IDERA | Products | Purchase | Support | Community | Resources | About Us Legal
  • No labels