How to Recover Corrupt SQL Server Backup Files

Follow the step by step guide to learn how to repair & recover corrupt SQL server backup(.bak) files and Export them back into SQL Server using SysTools SQL Backup Recovery Software.

STEP 1

Open SysTools SQL Backup Recovery Software from the installation location or Go to Start menu » Programs » SysTools SQL Backup » SysTools SQL Server Backup to launch the application.

*Note 
Software runs on Windows platform preinstalled with SQL 2017/2016/2014/2012/2008 Server application, as their proper configuration is required in importing database from recovered backup file.

 

sql backup recovery
STEP 2

Click on "Browse" button to load SQL Backup (BAK) file.

 

load-sql-bak-file
STEP 3

Select the backup file and Click "Open"

Select .bak file
STEP 4

The software gives you option to "Auto-Detect" the version of SQL .bak file. Or you can manually select the version of .bak file.

Auto Detect bak version
STEP 5

Click on the Multiple Backup Files Option to add multiple SQL backup files at once.

As soon as you select the Multiple Backup Files Option tab , software allows you to select one of the following options:

(a) Autodetect the SQL Server multiple backup (.bak) files.
(b) Let me choose the SQL Server multiple backup (.bak) files.

Add bak files
STEP 6

The software gives you option to add multiple bak file. You can add one single file by clicking on Add File/ option or You can add multiple backup file by clicking on Add Folder option

add multiple bak files
STEP 7

After selecting the SQL backup file, click OK to proceed further.

selection of bak file
STEP 8

Next ,Select the backup file(s) & click Recover to initialize the Recovery process:

recover bak data
STEP 9

As soon as the recovery process is initialized, software will start scanning and loading the selected .bak file.It shows complete details of items recovered after scanning the damaged SQL backup file. Click the Close button to proceed further.

scanning process
STEP 10

After completing the scanning process, software displays a complete preview of all the recovered elements from the BAK file such as; tables, views, stored procedures etc. Select the appropriate element or sub-element to preview the contents respectively.

preview all data
STEP 11

After previewing all the recovered items of corrupt BAK file, click on the Export button to export the recovered items accordingly.

export all data
STEP 12

Upon selection of the Export option, software pops a display window to choose between multiple Export To options such as:

SQL Server Database: Export the recovered backup file into SQL Server

SQL Server Compatible SQL Scripts: Export the Backup file into SQL Server compatible SQL Scripts i.e. *.sql

export option
STEP 13

Choose Authentication mode, If you choose Windows Authentication mode then click on drop down button to fill Server Name.Or if you have chosen SQL Server Authentication, then enter login credentials of SQL Server.

fill credentials
STEP 14

Select Create New Database to export recovered data on it or Choose Export to Existing Database to Overwrite the recovered database on an Existing database. Type the Database Name, which has not been already created in your SQL Server databases.

Create new database
STEP 15

Software will display default Collation type for your database.

Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types, and character width.

select collation
STEP 16

Now, Click on check box to export the desired components of database

export selected
STEP 17

Now upon successful authentication Select the Required Database items to Export along with multiple Export options such as

Export With Only Schema - This option lets you to create only schemas for the selected Tables, Views, Stored Procedures etc.

Export With Schema & Data - This option lets you to export schemas as well as data for the table.

Click "Save" to begin the export process.

export selected
STEP 18

If you want to export deleted records, check on the Export Deleted Records Click on Export.

export deleted records
STEP 19

An 'Export Completed Successfully' window will appear on screen confirming the successful export of the database. Click on OK

destination location
STEP 20

The software will show the status of exported records. Click on Close.

exporting data
STEP 21

Software ask you to export the detail to a .csv file. Click on Yes.

complete recovery
STEP 22

Browse the folder to save the .csv file or you can also make a folder to export the .csv file detail.

verify result
STEP 23

To check recovered database on SQL Server just expand the databases.

verify result