Vembu BDR Suite » Vembu Cloud Backup for File & Application » Microsoft SQL Server Backup » Restore Microsoft SQL Server Data » Restore From Vembu Client GUI

Restore From Vembu Client GUI

MS SQL Restore

Step 1- Select MS SQL backup:

Click restore option in the top menu.
Choose the MS SQL backup you wish to restore from the list of backups displayed and click on ‘Restore’ option alongside the backup.

This step has the following options:

‘Restore data from backup server’
‘I have previously restored data from my backup server to a local folder. I now want to use this data to restore the MS SQL Server’

Step 2- Restore data from backup server:

This option will ask the user to select database name and time-stamp version to restore from.
Once options are selected, databases will be shown along with an option to provide restore location.
Select the check-box Type and provide a restore location path.
Once done proceed to select restore settings.

Step 3- Step Select Restore settings:

This option allows two types of restores possible. They are:

After restoring data from the backup server, continue to automatically restore the data into SQL Server Database (This is the default option chosen).

Choosing this option will let user restore data into SQL Server database, where user has the option to either overwrite an existing database or restore as a separate database.

Restore the data to the local disk only and do not automatically restore the data into the SQL Server (I will separately run OnlineBackup through the 'locally restored files' to restore the SQL Server database later).

Choosing this option will restore data in a separate user defined location instead of restoring data into SQL Server.

Once done choosing restore option, click proceed.

Step 4- Select Recovery State:

This option gives user 3 options to choose from:

Leave database in ready-to-use state by rolling back uncommitted transactions. Additional transaction logs cannot be restored (Restore with recovery).
Leave database non-operational, and do not rollback uncommitted transactions. Additional transaction logs can be restored (Restore with Non-Recovery).
Leave database in read-only mode. Undo uncommitted transactions, but save undo action in a standby file so that recovery effects can be reversed (Restore with Standby).

Password protected- If the backup is password protected, enter the correct password to proceed with the restore.

Step 5- Review Configuration and Run Restore

Once all options are chosen, review the configuration provided and click 'Restore now'. Review restore progress and make sure it gets completed successfully.