How to Restore SQL Server Database Backup

STEP 1

Launch the SysTools SQL Server Recovery Manager and the following screen will appear on screen. Click on the ‘Recover Data From SQL Server Backup’ module from the panel.

STEP 2

Click on the Open button to add the SQL backup (BAK) file.

STEP 3

Select the backup file and click on Open to proceed further.

STEP 4

Click on Browse and add the SQL backup (BAK) file.

Note: Choose the right version of your SQL Server BAK file. Selecting the wrong version may result in inconsistent behavior. If you are not certain about the version navigate to Multiple Backup Files Option and select Auto Detect backup files option.

Check Recover Deleted Objects option to recover the deleted components. Click OK.

STEP 5

Multiple Backup Files Options

The software provide two choices:
(1) Auto detect the SQL Server multiple backup (.bak) files.
(2) Let me choose the SQL Server multiple backup (.bak) files.
Using these options, user can select multiple SQL server backup files at a time.
Click Add File/Folder option to load multiple SQL Server Backup Files accordingly:

STEP 6

Click OK after selecting the SQL Server backup file to proceed further.

STEP 7

Click on Recover button after selecting BAK file(s) to begin the process.

STEP 8

As soon as file recovery is initialized, the software will start scanning and loading the selected .bak file.
Complete details of the items recovered after scanning damaged SQL backup file will be at display. Click on the Close button to close the screen.

If you save your scanned file then on Yes otherwise click on NO.

STEP 9

Now you can see a complete preview of elements recovered from the BAK file. Select the appropriate element or sub-element to preview its respective contents.

Also, users can preview deleted database objects like Tables, Functions, Stored Procedures, Indexes, etc. preview-of-recovered-bak-file

STEP 10

Click on the Export button to export the recovered items accordingly after previewing them.

STEP 11

Upon selection of the Export option, a window to customize the export process will appear with following options:
SQL Server Database: Export the recovered backup file into a preferred SQL Server database.
SQL Server Compatible SQL Scripts: Export the backup file into SQL Server compatible SQL Scripts i.e. *.sql.
CSV Script: Export the backup file into CSV file format i.e. *.csv.

STEP 12

Choose Server Name by clicking the drop down arrow and then select the Authentication mode. If you are using SQL Server Authentication then enter the Login Credential for the SQL Server.

Select Create New Database to export recovered data into a new database or choose Export to Existing Database option to overwrite the recovered on existing database.

Choose required database components and you can check the Recovered Deleted Objects box to export the deleted data.

An Export Complete window appear on the screen ensuring the successful export of the database. Click on OK.

STEP 13

Or If you want to export the database as .sql file then choose the SQL Server Compatible SQL Script option.

STEP 14

Now, select the desired components and export with following options:
Export With Only Schema - This option lets you create only schemas for the selected Tables, Views, and Stored Procedures.
Export With Schema & Data - This option lets you export schemas as well as data for the table contents.

STEP 15

Users can also check the Recover Deleted Objects option to export deleted database objects

Click on "Save" to begin the export process:

STEP 16

If you want to database into .CSV file, Choose CSV Script option.

STEP 17

Now, select the desired tables and export with following options:
Export With Only Schema - This option lets you create only schemas for the selected Tables.
Export With Schema & Data - This option lets you export schemas as well as data.

STEP 18

Users can also check the Recover Deleted Objects/Recover Deleted Records option to export deleted Tables and Tables Records.

Click on "Save" to begin the export process:

SQL Server Database Backup & Recovery Process