Acronis Backup for Windows Server Essentials - User Guide - Manual (Page 308)

308 Copyright © Acronis International GmbH, 2002-2014
Leave the setting disabled if you use a third-party application, such as the SQL Server backup
and restore component, for backing up the SQL Server data.
Log truncation and ignoring application errors are mutually exclusive. This prevents truncating
the Microsoft SQL log if the application metadata is not collected.
12.4 Recovering Microsoft SQL Server data
This section describes only the steps and settings that are specific for recovering SQL databases from
a single-pass backup. The common settings of a recovery task are described in the "Creating a
recovery task" (p. 131) section.
You have two options for SQL database recovery:

Recover the databases to instances (p. 308).

Extract the database files to folders (p. 310).
12.4.1 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:

A system database can only be recovered to an instance of the same version as the original
instance.

A system database is always recovered in the "ready to use" state.

Because the master database records information about all databases of the instance, you may
need to perform additional actions after the database is recovered. For details, see "Actions after
a master database recovery" (p. 309).
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:

Overwrite existing database
This is the default setting that fits most situations. The database in the target instance will be
overwritten with the database from the backup.