Operation Manual

46 Copyright © Acronis International GmbH, 2002-2016
 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.
2.9.6.2 Attaching SQL Server databases
This section describes how to attach a database in SQL Server by using SQL Server Management
Studio. Only one database can be attached at a time.
Attaching a database requires any of the following permissions: CREATE DATABASE, CREATE ANY
DATABASE, or ALTER ANY DATABASE. Normally, these permissions are granted to the sysadmin role
of the instance.
To attach a database
1. Run Microsoft SQL Server Management Studio.
2. Connect to the required SQL Server instance, and then expand the instance.
3. Right click Databases and click Attach.
4. Click Add.
5. In the Locate Database Files dialog box, find and select the .mdf file of the database.
6. In the Database Details section, make sure that the rest of database files (.ndf and .ldf files) are
found.
Details. SQL Server database files may not be found automatically, if:
 They are not in the default location, or they are not in the same folder as the primary
database file (.mdf). Solution: Specify the path to the required files manually in the Current
File Path column.
 You have recovered an incomplete set of files that make up the database. Solution: Recover
the missing SQL Server database files from the backup.
7. When all of the files are found, click OK.
2.9.7 Recovering Exchange data
This section describes how to recover Exchange databases from the backups performed by Agent for
Exchange. For information about recovering Exchange 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 Exchange Server data to the original Exchange Server.
The following table summarizes the Exchange Server data that you can select for recovery and the
minimal user rights required to recover the data.
Exchange version
Data items
User rights
2003
Storage groups
Membership in the Organization Management
role group.
2007
Storage groups
Membership in the Exchange Organization
Administrators role group.
2010/2013
Databases
Membership in the Organization Management
role group.
Alternatively, you can recover the databases (storage groups) as files. The database files, along with
transaction log files, will be extracted from the backup to a folder that you specify. This can be useful
if you need to extract data for an audit or further processing by third-party tools, or when the