Stellar Knowledge Base

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

 Modified on: August 17, 2020 |    13618 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 Select File if you are aware of the location and name of the .BAK file.

SQl backup recovery

  • Alternately, click on Search in Folder to locate the file. Next click on Search file and all files with .bak extension display in the File Path box.
  • 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)
  • 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

Select backup set

  • 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 MS SQL Radio button and Browse and Select the Destination Path and click on OK button. Similarly, choose other file formats to save the SQL database.

SQL backup file saving formats

  • Select the option to save the recovered SQL Database from backup. Select the New Database

Options for saving sql backup file

  • 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.

Saving complete of SQL backup 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