45 Copyright © Acronis International GmbH, 2002-2016
To recover a database as a different one to the same instance:
a. Click the database name.
b. In Recover to, select New database.
c. Specify the new database name.
d. Specify the new database path and log path. The folder you specify must not contain the
original database and log files.
10. [Optional] To change the database state after recovery, click the database name, and then
choose one of the following states:
Ready to use (RESTORE WITH RECOVERY) (default)
After the recovery completes, 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 completes, 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.
11. Click Start recovery.
12. If the original databases were selected as the destination, confirm overwriting the databases
with their backed-up versions.
The recovery progress is shown on the Activities tab.
2.9.6.1 Recovering system databases
All system databases of an instance are recovered at once. When recovering system databases, 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 system databases:
System databases can only be recovered to an instance of the same version as the original
instance.
System databases are always recovered in the "ready to use" state.
Recovering the master database
System databases include the master database. 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 by
using SQL Server Management Studio.
