After backing up SQL Server databases using Image Plug-in version 7.5 or later, you can restore database files, tables and objects from the application-consistent backups.
To restore database files from Image Plug-in backups, you must mount a safeset as a drive on the computer where you want to restore database files. You can then restore files using Windows Explorer or tables and other objects using the Granular Restore for Microsoft Exchange and SQL application.
To restore SQL Server database files or objects from an Image Plug-in backup:
1. On the navigation bar, click Computers.
A grid lists available computers.
2. Find the computer with the SQL Server database backup created using the Image Plug-in, and expand its view by clicking the row for the computer.
3. Click the Jobs tab.
4. Find the job with the database you want to restore, and click Restore in the Select Action menu for the job.
The Choose how to restore dialog box appears.
5. Select Individual File or Folders.
6. Click Continue.
The Restore dialog box shows the most recent safeset for the job.
7. To restore data
from an older safeset, click the calendar button. In the calendar that appears, click the
date of the safeset from which you want to restore. To the right of the
calendar, click the specific safeset that you want to use.
9. In the
Encryption Password box, enter the data encryption password. To view the
password hint, click the Hint button.
10. In the Volume to Restore column, select each backed-up volume from which you want to restore files and folders.
11. In the Volume Mount Drive Letter column, choose the drive letter for mounting each volume.
12. Click Mount Volumes.
13. If a confirmation message appears, read the message, and then click Continue.
The Process Details dialog box appears. When each volume is mounted, the drive letter is shown at the right side of the dialog box.
14. Do one of the following:
• To restore SQL Server databases, use Windows Explorer to browse to the location of the database files and copy the database files (.mdf and .ldf) that you want to restore. If a databaseName_mod folder exists, copy the databaseName_mod folder as well. You can then attach the database in Microsoft SQL Server.
• To restore SQL Server database tables or objects, launch the Granular Restore for Microsoft Exchange and SQL application on a SQL Server system. In the Granular Restore application, choose File > Open, drill down into the volume to choose the .mdf file, then select and restore your data. For more information, see documentation for the Granular Restore for Microsoft Exchange and SQL application.
15. When you are done restoring database files, click Stop to remove the mounted drives.
If you do not click Stop, the drive will be unmounted automatically after the number of minutes of inactivity specified in the Idle Time box. See Step 8.