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

309 Copyright © Acronis International GmbH, 2002-2014

Rename the recovered database
This setting lets you retain the existing database. A recovered database will have the
following name: <original database name>-Recovered. If a database with this name
already exists, the recovered database will be named as follows: <original database
name>-Recovered (<sequence number>).
Examples: MyDatabase-Recovered, MyDatabase-Recovered (2).
6. For each database being recovered, you can select its state after recovery. To do so, click the
icon to the left of the database name, and then select one of the following values:

Ready to use (RESTORE WITH RECOVERY) (by default)
After the recovery competes, the database will be ready for use. Users will have full access to
it. The software will roll back all uncommitted transactions of the recovered database that
are stored in the transaction logs. You will not be able to recover additional transaction logs
from the native Microsoft SQL backups.

Non-operational (RESTORE WITH NORECOVERY)
After the recovery competes, the database will be non-operational. Users will have no access
to it. The software will keep all uncommitted transactions of the recovered database. You
will be able to recover additional transaction logs from the native Microsoft SQL backups and
thus reach the necessary recovery point.

Read-only (RESTORE WITH STANDBY)
After the recovery completes, users will have read-only access to the database. The software
will undo any uncommitted transactions. However, it will save the undo actions in a
temporary standby file so that the recovery effects can be reverted.
This value is primarily used to detect the point in time when a SQL Server error occurred.
7. You can change the paths to where the database files will be saved. To access these settings, click
the icon to the left of the database name.
8. Under How to recover, select whether to use Acronis Active Restore (p. 309) during recovery.
9. Specify other settings of the recovery task as appropriate.
12.4.1.1 Actions after a master database recovery
The master database records information about all databases of the instance. Hence, the master
database in a backup contains information about databases which existed in the instance at the time
of the backup.
After recovering the master database, you may need to do the following:

Databases that have appeared in the instance after the backup was done are not visible by the
instance. To bring these databases back to production, attach them to the instance manually. For
instructions on how to do this by using SQL Server Management Studio, see the "Attaching SQL
Server databases" (p. 291) section.

Databases that have been deleted after the backup was done are displayed as offline in the
instance. Delete these databases by using SQL Server Management Studio.
12.4.1.2 Using Acronis Active Restore for SQL database recovery
Active Restore is an Acronis proprietary technology. It brings a Microsoft SQL database online
minutes after the database recovery is started. This allows users to access their data while the
databases are still being recovered. Therefore, using Active Restore makes sense when you recover
the databases to the Ready to use or Read-only state.