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

311 Copyright © Acronis International GmbH, 2002-2014
12.5 Mounting SQL Server databases from a single-pass
backup
When you mount a backed-up SQL database, it is temporarily attached to your SQL Server in the
read-only mode. You can access the database like any other database of the instance.
Mounting databases comes in handy when you need any of the following:

To granularly restore individual database objects, such as tables, records, stored procedures.
Mount the database and use third-party tools to get the necessary information from it.

To quickly access historical information. Recovery of a large database may take a long time. If you
mount the database, you do not have to wait until the database is recovered.

To view the state of a database as of a certain point in time (for example, for data mining or
audit).
The mount operation is available when the console is connected to a machine where Agent for SQL is
installed. The single-pass backup must be stored in a local folder on that machine (except optical
disks), in Acronis Secure Zone, or on a network share. Other locations are not supported by the
mount operation.
System databases are mounted as user databases.
To mount a SQL Server database
1. Connect the console to a machine where Agent for SQL is installed.
2. On the Actions menu, click Mount SQL databases from image.
3. Click Select data, and then select the backup and the databases you need to mount.
4. Acronis Backup tries to specify the target instances for the selected databases by taking the
original paths from the backup. If the target instance is not selected for some database or if you
want to mount the database to another instance, specify the target instance manually.
If your current account does not have enough privileges to access the target SQL Server instance,
you will be asked to provide the credentials.
5. Сlick OK.
A mounted database has the following name: <original database name>-Mounted. If a
database with this name already exists, the mounted database is named as follows: <original
database name>-Mounted (<sequence number>).
Examples: MyDatabase-Mounted, MyDatabase-Mounted (2).
12.5.1 Unmounting mounted SQL Server databases
Maintaining the mounted databases takes considerable system resources. It is recommended that
you unmount a database after the necessary operations are completed. If a database is not
unmounted manually, it will remain mounted until the operating system restarts or until the agent
service restarts.
To unmount a SQL database
1. Connect the console to a machine where Agent for SQL is installed.
2. In the Navigation pane, click Manage mounted SQL databases.
3. To unmount one database, select it and click Unmount. To unmount all of the mounted
databases at once, click Unmount all.