Recovering SQL databases to instances

Within a single recovery task, you can recover multiple databases. The databases are automatically mapped to their original instances. You can select a target instance for each database, if necessary.

System databases are recovered in the same way as user databases. When recovering the master database, the software automatically restarts the destination instance in the single-user mode. After the recovery completes, the software restarts the instance and recovers other databases (if any). Other things to consider when recovering a system database:

To recover databases to instances

On the Recover data page:

  1. Under What to recover, click Select data and select the databases.
  2. If the console is connected to the management server, select the registered machine where you want to recover the databases. Otherwise, skip this step.
  3. Select Recover the databases to instances.
  4. Acronis Backup tries to specify the target instances for the selected databases by taking the original paths from the backup. If the target instance is not selected for some database or if you want to recover the database to another instance, specify the target instance manually.

    If your current account does not have enough privileges to access the target SQL Server instance, you will be asked to provide the credentials.

  5. If the target instance contains a database that has the same name as the one being recovered, the software displays a warning: The target database already exists. You have the following options:
  6. For each database being recovered, you can select its state after recovery. To do so, click the ico_triangle_collapsed1 icon to the left of the database name, and then select one of the following values:
  7. You can change the paths to where the database files will be saved. To access these settings, click the ico_triangle_collapsed1 icon to the left of the database name.
  8. Under How to recover, select whether to use Acronis Active Restore during recovery.
  9. Specify other settings of the recovery task as appropriate.

In this section

Actions after a master database recovery

Using Acronis Active Restore for SQL database recovery