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:
    1. In Mount for, select All users that share this machine.
    2. Select the volume(s) containing the SQL Server database files. For the instructions on how to find out the database paths, refer to "SQL Server database files".
    3. Choose the Read/write access mode.
    4. Specify drive letters that will be assigned to the mounted volumes.
  5. After the volumes are mounted, use instructions from the "Attaching SQL Server databases" section to attach the databases directly from the mounted volumes.
  6. Perform the required operations with the newly attached databases.
  7. After the necessary operations are completed, detach the database from the instance by using Microsoft SQL Server Management Studio. To do this, right-click the database and select Tasks > Detach.
  8. Unmount the mounted volumes:
    1. In the main menu, select Navigation > Mounted images.
    2. Select the image and click Unmount.

    Details. When mounting an image in the "Read/write" mode, Acronis Backup & Recovery 11.5 creates a new incremental backup. We strongly recommend deleting this incremental backup.