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

204 Copyright © Acronis International GmbH, 2002-2014
To bring a backed-up database back to production, recover the database files from a disk backup. For
details, see "Recovering SQL Server databases from a disk backup" (p. 204).
If you only need temporary access to the backed-up databases for data mining or data extraction,
mount a disk backup and access the required data. For details, see "Accessing SQL Server databases
from a disk backup" (p. 204).
11.2.1 Recovering SQL Server databases from a disk backup
This section describes how to recover SQL Server databases from a disk backup.
For the instructions how to find out the database paths, refer to "SQL Server database files" (p. 195).
To recover SQL Server databases
1. Connect the console to the machine on which you are going to perform the operation.
2. Navigate to the vault containing the disk backup with the SQL Server database files.
3. Click the Data view tab. In the Show list, click Folders/files.
4. Select the required SQL Server database files and click Recover. By default, the data will be
reverted to the state of the latest backup. If you need to select another point in time to revert
the data to, use the Versions list.
5. On the recovery page under What to recover section:
a. In Data paths, select Custom.
b. In Browse, specify a folder where the files will be recovered to.
Note: We recommend that you recover the SQL server database files to a folder local to the SQL Server,
since all of the SQL Server versions earlier than SQL Server 2012 do not support databases located on
network shares.
c. Leave the rest of the settings "as is" and click OK to proceed with recovery.
6. After the recovery is complete, attach the databases according to the instructions described in
the "Attaching SQL Server databases" (p. 205) section.
Details. If for any reason you did not recover all of the SQL Server database files, you will not be
able to attach the database. However, the Microsoft SQL Server Management Studio will inform
you about all the paths and names of the missing files and it will help you to identify what
particular files the database consists of.
11.2.2 Accessing SQL Server databases from a disk backup
If you want to access the SQL Server databases for data mining or other short-term purposes, you
can use the Mount image operation instead of recovery. Just mount volumes (containing the
required database files) from a disk backup (image) in the "Read/write" mode and you are free to
attach databases, modify database files and work with them as if they were on a physical disk.
You can mount volumes if the disk backup is stored in a local folder (except optical media such as CD,
DVD, or Blu-ray Discs), Acronis Secure Zone, or on a network share.
To attach databases contained in a disk backup to SQL Server
1. Connect the console to the SQL Server where Agent for Windows is installed.
2. In the main menu, select Actions > Mount image.
3. In the What to mount section, select the source archive and specify the backup.
4. In the Mount settings section:
a. In Mount for, select All users that share this machine.