44 Copyright © Acronis International GmbH, 2002-2016
2.9.5 Recovering system state
1. Select the machine for which you want to recover the system state.
2. Click Recovery.
3. Select a system state recovery point. Note that recovery points are filtered by location.
4. Click Recover system state.
5. Confirm that you want to overwrite the system state with its backed-up version.
The recovery progress is shown on the Activities tab.
2.9.6 Recovering SQL databases
This section describes how to recover SQL databases from the backups performed by Agent for SQL.
For information about recovering SQL databases from application-aware backups of virtual machines,
refer to "Recovering databases from application-aware backups" (p. 53).
The backup service enables you to recover SQL databases to a SQL Server instance, if Agent for SQL is
installed on the machine running the instance. You will need to provide credentials for an account
that is a member of the Backup Operators or Administrators group on the machine and a member of
the sysadmin role on the target instance.
Alternatively, you can recover the databases as files. This can be useful if you need to recover
databases to a machine where Agent for SQL is not installed, or you need to extract data for data
mining, audit, or further processing by third-party tools. You can attach the SQL database files to a
SQL Server instance, as described in "Attaching SQL Server databases" (p. 46).
System databases are basically recovered in the same way as user databases. The peculiarities of
system database recovery are described in "Recovering system databases" (p. 45).
To recover SQL databases
1. Click Microsoft SQL.
Machines with Agent for SQL installed are shown.
2. Select the machine that originally contained the data that you want to recover.
3. Click Recovery.
4. Select a recovery point. Note that recovery points are filtered by location.
If the machine is offline, the recovery points are not displayed. Do one of the following:
If the backup is located in the cloud storage, click Select machine, select an online machine
that has Agent for SQL, and then select a recovery point.
Select a recovery point on the Backups tab (p. 48).
The machine chosen for browsing in either of the above actions becomes a target machine for
the SQL databases recovery.
5. Click Recover SQL databases.
6. Select the data that you want to recover. Double-click an instance to view the databases it
contains.
7. If you want to recover the databases as files, click Recover as files, select a local or a network
folder to save the files to, and then click Recover. Otherwise, skip this step.
8. Click Recover.
9. By default, the databases are recovered to the original ones. If the original database does not
exist, it will be recreated. You can select another machine or another SQL Server instance to
recover the databases to.
