The Target tab of the Restore wizard allows you to 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, click Register SQL Server to add a new instance. For more information, see register an instance. 
  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 - 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 in 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   to add the .cmd file. You can also select 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