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.
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.
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.
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.
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.
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
SQL Server Compatible SQL Scripts: Export the Backup file into SQL Server compatible SQL Scripts i.e. *.sql
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.
An 'Export Completed Successfully' window will appear on screen confirming the successful export of the database. Click on OK
Browse the folder to save the .csv file or you can also make a folder to export the .csv file detail.