IBackup Professional SQL Server Restore wizard guides you through a simple step-by-step approach to help you restore database backup files (*.dmp) from your IBackup Professional account to 'MS SQL Server'.

It provides two options to restore the database backup file (*.dmp) into your MS SQL Server. The first lets you restore the database backup file (*.dmp) from your IBackup account to the MS SQL Server. The latter allows for restore of the database backup file (*.dmp) from your local computer to the MS SQL Server.

Follow the steps given below to restore MS SQL Server database file (*.dmp)

Option 1:

Restore the SQL Server database backup file ('*.dmp) from your IBackup Professional account to your MS SQL Server.

Step 1.
Select the SQL Server Restore option from the main menu item: Backup-Restore > SQL Server > SQL Server Restore.

Step 2.
Select the option ‘Restore the SQL Server database backup file ('*.dmp) from your IBackup Professional account to your MS SQL Server' on the 'SQL Server Restore' wizard.

Step 3.
Provide the relevant authentication information when prompted.
Click to know more about MS SQL Server authentication.

Step 4.
Select the database backup files (*.dmp) from your IBackup Professional account.

Step 5.
Browse to select the destination directory and then click on the ‘Ok’ button to restore the database files to your local computer.

Step 6.
Click on the ‘SQL Restore’ button to restore the database backup file (*.dmp) to your SQL Server.

Option 2:

Restore the SQL Server database backup file ('*.dmp) from your local computer to your MS SQL Server.

Step 1.
Select the SQL Server Restore option from the main menu item: Backup-Restore > SQL Server > SQL Server Restore.

Step 2.
Select the option 'Restore the SQL Server database backup file ('*.dmp) from your local computer to your MS SQL Server' on the 'SQL Server Restore' Wizard.

Step 3.
Provide the relevant authentication information when prompted.

Step 4.
Select the database backup file (*.dmp) from your local computer (the location where the database backup file (*.dmp) was restored earlier from your IBackup Professional account).

Step 5.
Click on the ‘SQL Restore’ button to restore the selected database files (*.dmp) to your MS SQL Server.