Complete the following steps.
- Launch the Core Console.
- Click on the agent machine and go to the Recovery Points tab.
- Expand the desired recovery point from which you wish to restore by clicking the arrow beside it.
- Click Mount.
- 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.
- 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.
- In the Mount dialog box, choose Writable.
- 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).
- After the required fields have been filled in the Mount dialog box, click Mount.
- 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.
- 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.
- Use the SQL Server Management Studio application to attach the database, and then copy over any desired data.
-
- Open and log into the SQL Server Management Studio application.
- 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.
- 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.
- After the database is attached, use any of the typical SQL tools to retrieve the data.
- After mounting and attaching the database, do one of the following:
- Copy the table or rows back to the original database by using either INSERT, BCP (Bulk Copy Utility), or SELECT INTO.
- Right-click on the original database name, select Tasks, and then click Import Data.
- Point to the attached database or recovery point on the Core.
- 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.