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
Go to Start » All Programs » SysTools SQL Backup Recovery
Note: Software runs on Windows platform preinstalled with SQL 2019 / 2017/ 2016 / 2014 / 2012 / 2008 Server application, as their proper configuration is required in importing database from recovered backup file.
Click on Browse button to load SQL Backup (BAK) file
Select the backup file and click Open
The software gives you option to Auto-Detect the version of SQL .bak file. Or you can manually select the version of .bak file
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.
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
After selecting the SQL backup file, click OK to proceed further
Next ,Select the backup file(s) & click Recover to initialize the Recovery process
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.
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.
The user can preview deleted stored procedures of SQL database.
The user can preview deleted rules by using this software.
The user can preview deleted functions using this software.
The user can preview deleted Triggers using this software.
The user can preview deleted Views using this SQL Backup Recovery software.
After previewing all the recovered items of corrupt BAK file, click on the Export button to export the recovered items accordingly.
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
CSV File Format: Option to Export selected tables schema and data in CSV file format
Browse the Destination location to save your CSV file.
SQL Server Compatible SQL Scripts: Export the Backup file into SQL Server compatible SQL Scripts i.e. *.sql
Browse the Destination location to save your script file.
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.
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.
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.
Now, Click on check box to export the desired components of database
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.
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.
An Export Completed Successfully window will appear on screen confirming the successful export of the database. Click OK
The software will show the status of exported records. Click on Close.
Software ask you to export the detail to a .csv file. Click on Yes.
Browse the folder to save the .csv file or you can also make a folder to export the .csv file detail.
To check recovered database on SQL Server just expand the databases
Free Download SQL Backup Recovery Software Download Now