Step 1: Select the database and choosing the restore type.
Once the database is selected and Restore to MSSQL Server is chosen as the recovery option, you can click on next to proceed to further 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 up to which 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.
Download
You can download the database file to any location on this server or to the source MSSQL Server using this recovery option.
Step 1: Select the database and choosing the restore type.
Once the database is selected and Restore to MSSQL Server is chosen as the recovery option, you can click on next to proceed to further steps.
Step 2: Select the Restore Version
- Destination: Choose either ‘This Server’ or ‘Source MSSQL Server’.
- Selected Database: To Restore to the SQL Server, the selected database is shown.
- Restore Point: Choose the required time stamp from the drop down menu
- Restore Location: As per the destination chosen you can browse the location in the local server or the source MSSQL Server where you want the data to be restored.
- Select Database Files to restore: From the list of database files choose the one you wish to restore and proceed.
Step 3: Review & Restore
Review the recovery configuration and click on Restore.