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).