News We Recently Launched AD Migrator and AD Reporter.

SysTools SQL Backup Recovery Software: Know How it Works!

How to Recover Corrupt SQL Server Backup Files

Follow the step-by-step guide to repair corrupt SQL Server Backup (.bak) file using SysTools SQL Backup Recovery Tool

STEP 1

Go to Start » All Programs » SysTools SQL Backup Recovery

Note: Software runs on Windows platform preinstalled with SQL 2022 / 2019 / 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 file 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

Select Files
STEP 8

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

recovery bak file
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. This software will shows the deleted database objects in red color.

preview all data
STEP 11

The user can preview deleted stored procedures of SQL database.

preview all data
STEP 12

The user can preview deleted rules by using this software.

preview all data
STEP 13

The user can preview deleted functions using this software.

preview all data
STEP 14

The user can preview deleted Triggers using this software.

preview all data
STEP 15

The user can preview deleted Views using this SQL Backup Recovery software.

preview all data
STEP 16

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

export bak file data
STEP 17

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

export option

CSV File Format: Option to Export selected tables schema and data in CSV file format

export in script

Browse the Destination location to save your CSV file.

save script

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

export in CSV

Browse the Destination location to save your script file.

save CSV

STEP 18

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 19

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 20

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 21

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

export selected
STEP 22

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 with schema and data
STEP 23

If you want to export deleted records and deleted objects, check on the Export Deleted Records and deleted object option. After that Click on Export.

export deleted records
STEP 24

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

destination location
STEP 25

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

exporting data
STEP 26

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

complete recovery
STEP 27

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

verify result
STEP 28

To check recovered database on SQL Server just expand the databases

verify database

Free Download SQL Backup Recovery Software Download Now