Restoring SQL Databases (4033403)

You need to recover a SQL database or table from a recovery point.

Click here for a step by step instructional video of this process.

Complete the following steps.

1. Launch the Core Console.
2. Click on the agent machine and go to the Recovery Points tab.
3. Expand the desired recovery point from which you wish to restore by clicking the arrow beside it.
4. Click Mount.
   1. In the Mount dialog box, specify the path to mount this recovery point. This will be the location to access the data in Windows Explorer.
   2. In the Mount dialog box, specify which volumes to mount. You must choose at least one volume. If you have multiple volumes you can mount all volumes at the same time.
   3. In the Mount dialog box, choose Writable.
   4. In the Mount dialog box, if you would like to mount the recovery point as a network share you can do this as well. Check ‘Create a Windows share for this Mount’ checkbox, then enter the share name and specify which users/groups have access (optional).
5. After the required fields have been filled in the Mount dialog box, click Mount.
6. The Recovery Points tab will automatically return until the mount begins, at which time a ‘Monitor Task’ window will display to view the progress of the mounting job.
   • Users can also view mounting progress from the events tab.
7. Once the mount is completed, open windows explorer and navigate to the mount path that was specified in Step 4.
   • You can also locate all current mounts from Core>Tools>Mounts. This displays all mounted recovery points in the system at the given time and the location where they are mounted to.
8. Use the SQL Server Management Studio application to attach the database, and then copy over any desired data.
   • To attach the database:
   1. 1. Open and log into the SQL Server Management Studio application.
      2. Attach the database by pointing to the mounted recovery point volume(s). **Note: SQL Version must be same edition as source or higher.  ie: Standard edition cannot open Enterprise SQL database.
      3. If the logs are in another location other than the same as the databases, make sure to correct the “Attach dialog” path to the correct location for the respective log files.
9. After the database is attached, use any of the typical SQL tools to retrieve the data.
10. After mounting and attaching the database, do one of the following:
    1. Copy the table or rows back to the original database by using either INSERT, BCP (Bulk Copy Utility), or SELECT INTO.
    2. Right-click on the original database name, select Tasks, and then click Import Data.
    3. Point to the attached database or recovery point on the Core.
11. Once data has been recovered, it is a good idea to dismount the recovery point. This can be accomplished from the Core>Tools>Mounts page by clicking ‘Dismount’ on the mounted recovery point.
    • Note: stopping the Core Service will dismount all active mounted recovery points.

For more information on various SQL commands, click here.