Restoring a MS SQL Database

R1Soft CDP provides the ability to take a snapshot of the Microsoft SQL server databases. Since CDP is using the VSS SQL writers, it ensures data integrity and consistency during the backup operation.

Follow the instructions below to restore a MS SQL database previously backed up by R1Soft CDP.

Step 1: Restoring Database Data and Log Files

To restore a database, follow the instructions below in your CDP Server System.

1. Access the Disk Safe Browser as described in Accessing the Disk Safe Browser.

2. The Disk Safe Browser opens. All of your Disk Safes will be listed on the right side of the page.

3. Select a Disk Safe from the file system tree on the left.
Read more in Disk Safes.

4. Select a Device from the file system tree on the left.
Read more in Devices.

5. Select the snapshot you want to restore from. Since each backup is a virtual full backup, you can restore the files from any previous backup/snapshot.

6. Browse to locate the location of the SQL data and log files (.mdf and .ldf).

7. Check off the database .mdf data files and .ldf log files you want to restore.

If the database already exists and you want to restore the .mdf and .ldf files to an alternate location, check the option and specify the path where the files will be restored.

10. When you are finished selecting the files and directories, select the "Restore Selected Files" from the drop-down menu and click "Go".

11. Continue as described in Restoring Files, Step 11.

Note
If the database already exists and you want to restore the .mdf and .ldf files to an alternate location, check the option and specify the path where the files will be restored.

Step 2: Attaching the Database Data and Log Files

Follow the instructions below to attach the database data and log file.

1. From the SQL Server Management Studio, right-click the "Databases" item and select the "Attach..." command in the menu.

2. Browse to the restore location.

Note
If you restored it to an alternate location, the path will include the new location as well as the old hierarchy of the file location.

3. In the "Attach As" column, change the database name if the original database is still online.

4. Click OK. The database is now attached.