Vembu BDR Suite » Offsite Copy/DR » Enabling Offsite Copy Management » Vembu Offsite DR Server (To Your Data Center) » Recovery » Restore File & Application Backup » MS SQL Restore

MS SQL Restore

Your MS SQL database data that you have backed up to the BDR Backup Server and replicated to the Offsite DR Server can be restored. The steps are explained below.

How to begin the restoration process?

Login to your Offsite DR Server and choose the Recovery tab. In the recovery page, click Restore option beside the corresponding MS SQL backup that is to be recovered. In case you are not able to identify it with the backup name, you can identify it with the plugin type from the plugin tab

Step 1: Select Version and Files to Restore

A tree listing various backup time-stamps with the full backup as its parent node will be displayed. This list that is generated is based on incremental and retention configured. In case the additional full backup is configured, then there will be more than one parent node list based on the configuration. The first step will be to select the restore version and click Next to proceed with the restore process

Once done choosing required time-stamp, proceed to select the backed up files/folders to restore

You can select files/folders in 3 ways. You can:

Select the root folder to proceed to restore entire backed up data for the chosen time-stamp
Select specific files and folders alone based on your requirement and proceed with the restore
By using the filter option the user can list out only the particular type of files by entering the database file type extension (*.mdf, *.ldf) and multiple files can also be listed by separating them using comma(,) Example: *.txt,*.xml. Proceed to configure the restore settings by selecting Next

Step 2: Select Restore Settings

The next step in the restore process will be to configure the Restore Settings for the restore.
Restore deleted files - This gives 3 options to choose from which are explained below

Skip deleted files
Deleted files only
Include deleted files

Skip deleted files (Restore backup data skipping deleted files) - Choosing this option will not restore the deleted files and skip them instead.

Deleted files only (Restore deleted files alone) - This option will restore the files that are deleted alone and omit the other backed up data from the restore process.
Include deleted files (Restore backup data along with deleted files) - This option will restore the backup data along with the deleted files.

You can compress your restore data and download it in a zip format by selecting the Enable Compressed Restore Data. Your compressed restore data can also be encrypted by enabling the ‘Encrypt Compressed Data’ option.

Note: The password you enter should satisfy the following conditions: The password should contain only the characters [a-z] [A-Z] [0-9] The password should contain at least 6 characters and at most 12 characters The password should not contain spaces or other special characters Provide restore location for the backed up files and click Next to proceed to restore your data

Step 3: Review Configurations

You have reached the final step of the restore process wherein you have to review the configuration you have provided and click the Restore Now option. This will trigger the restoration process. Review the restore progress and make sure it gets completed successfully.

Once you trigger the restore, you can track its progress from the restore progress tab. After being redirected to the Restore page, choose the inverted arrow mark in the status section to view the page displayed below.

The Restore Progress page consists of details such as:

Backup Schedule: The name of the backup that is being restored

Client Name: The name of the client from which the backup was triggered

Current File: The file that is being restored at the moment

Total Files: The count of the total number of files that have to be restored

Transfer Rate: The rate at which the restore is happening

Files Restored: The count of the files that were restored successfully

You can abort your restore if not required from the Abort (-) option available in that window. You will get a pop up as shown below. Click OK to Abort your restore.

Note: To enhance your restore performance, close the progress window and open it only occasionally to check the restore progress.

You can suspend your restore if not required from the Suspend option available in that window. You will get a pop up as shown below. Click OK to Suspend your restore.