Simple steps to restore corrupt SQL backup file using SQL backup recovery software. The software supports all type of backup.">

Stellar Knowledge Base

How to restore corrupt .BAK file using Stellar Toolkit for MS SQL

 Modified on: March 22, 2021 |    15554 views

Follow the below-mentioned steps to Restore corrupt .BAK file using Stellar Toolkit for MS SQL:

 

  • Download, Install and Run Stellar Toolkit for MS SQL on your system. Click on SQL Backup Recovery icon. The User Interface provides the list of steps for SQL backup recovery.
  • From the available software, click on Browse if you are aware of the location and name of the .BAK file.

  • Alternately, click on Search to find the file in particular drive or folder.
  • Select the corrupt .bak file which you need to recover.
  • Next, click on Scan button to start the scanning process. Select Backup Set dialog box appears with details on the backups taken in different Backup Modes, and list of all backups (in case the backup is stored in separate files)
  • The software provides two scan options, Standard scan and Advanced scan. Choose any one as per the severity of corruption.

  • Select the right backup set. There is a possibility that the same backup is stored in multiple files, then select all the files and perform recovery

  • Click on Next button to start the scanning process. The software counts and displays total records in the database after complete database scan. Number of total records available in the backup file is available as Logs

A preview of a total number of records is available in Tree-view format

Note: Before starting the SQL backup file restore from a .bak file, check the following:

  1. MS SQL Server is installed and running on the system
  2. Services of MS SQL are running on the system
  3. Once recovered, save the .BAK files in MSSQL (MDF), CSV, HTML and XLS format
  • Go to the main tab (or Quick Access Toolbar) and click on Save button. The Save As dialog box opens
  • Check box for MDF Radio button and Browse and Select the Destination Path and click on OK button. Similarly, choose other file formats to save the SQL database.
  • Select the option to save the recovered SQL Database from backup. Select the New Database

  • In Connect to Server option, select Server / Instance Name and choose a destination for saving the recovered database file and click on Connect button.

  • The recovered .BAK File is saved as New Database file in MS SQL Format
  • A confirmation message displays after successful completion of MS SQL Database from .BAK file.

If required, there is an option to save the Log Report also along with restore SQL database.

 

4 User Comments

OK

JERRY

Stellar support

Hi,

Thank you for contacting Stellar Data Recovery.

We have replied to the query on email.

Warm Regards

Stellar Support

Is it compatible with mysql server 2019?

Roberto Innaimi

Rajeev

Dear Roberto,

You may try the demo version of the application to check whether it is working or not. Stellar Backup Extractor for MS SQL comes in a bundle with Stellar Toolkit for MSSQL application. It supports MS SQL Server 2017, 2016, 2014, 2012, 2008 and older versions.

For any further query, request you to use the below link to contact our support team:

https://www.stellarinfo.com/support/

Regards,
Stellar Data Recovery

 

User Comments


 

 

Stellar Toolkit for MS SQL Stellar Toolkit for MS SQL is a combination of three tools developed to recover database from corrupt SQL server, extract database from corrupt SQL backup file and to reset SQL Server Password.

Learn More

 

Related Articles