Restore to SQL Server

The step 1 is to select the database and choosing the restore type. Once the database is selected and Restore to MSSQL Server is chosen as the rechttps://img.vembu.com/guide/img/2023/her steps.

Step 2: Select the Restore Version

To Restore to the SQL Server, the selected database is listed. Choose the required time stamp from the drop down menu and choose the location in the MSSQL Server where you want the data to be restored by entering or choosing the path.

Select Database Files to restore

From the list of database files choose the one you wish to restore and proceed.

Step 3: Restore Options

• Target Database: You can either use an existing database by clicking on the drop down list or create a new one where you want to restore.
• Restore Option: If you choose to restore to an existing database then select if you want to overwrite the existing database or choose to not overwrite so that the original database is intact.

Original File Name

The original file’s name selected will be shown and you can opt to restore the database to the original location itself or enter a new path for restore.

Recovery State

You can choose from the three different states which are as follows;

• Restore with Recovery – By selecting this option you can leave the database ready for use by rolling back the uncommitted transactions. Additional transactional logs cannot be restored.
• Restore with No Recovery – By selecting this option you choose the leave the database non – operational and do not roll back the uncommitted transactions. Here the additional transactional logs can be restored.
• Restore with standby – By selecting this option you can leave the database in read-only mode. You can roll back the uncommitted transactions but make sure to save the rollback operation in a file so that the recovery effects can be undone. Also, when this option is selected, enter the path to the standby file.

Step 4: Review & Restore

Review the recovery configuration and click on Restore.