How to repair corrupt SQL Database (.mdf and .ndf) files

In this article, we will see How to repair corrupt SQL Database (.mdf and .ndf) files

If you are working with the SQL database then usually you may face the problem of data corruption, whether taking backup on the daily basis is a good practice for data safety but however, if the backup is also corrupted, what should you do then?

Product Review of Stellar Repair for MS SQL


DBCC CHECKDB is an in-built utility provided by Microsoft SQL Server with multiple repair options to fix SQL database corruption, However, DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS causes data loss, while fixing major SQL issues. Repairing by DBCC CHECKDB with Allow data loss option will lead to the data loss while repairing the file but you may try these if it works for you.

You must try these commands if they work for you:

Image1

If the in-built utility DBCC CHECKDB isn’t fitted for you or even if you don’t want to lose your data then Stellar Repair for MS SQL is very useful to you.

What is Stellar Repair for MS SQL?

Stellar Repair for MS SQL is a most desirable tool used to repair the corrupt MS SQL Database files (.mdf and .ndf), recommended by database administrators and tech communities worldwide.
The Software has unique features that make it different from others like, it Repairs corrupt SQL Database (.mdf and .ndf) files, also
recovers the database components(tables, indexes, triggers, keys, rules & stored procedures, one of the best feature is it also recovers deleted records from the corrupted database.
It allows to save the database scan results by this you can resume data recovery at a later stage, and also allows us to save the repaired file in different formats like MS SQL, HTML, XLS, & CSV formats,

It supports almost all the versions of MS SQL Server 2008 to 2016 and older versions.

Why Stellar Repair for MS SQL?
Is SQL Server Log file (.LDF) Lost or Corrupted?
When DBCC CHECKDB Repair fails?
If your MS SQL Database is in SUSPECT mode also your data values more than money?

So, in situations like any of the above, Stellar Repair for MS SQL is a very useful tool, you just need to download it from https://www.stellarinfo.com/sql-recovery.php  , in the free trial version you will be able to scan and preview recoverable SQL server database objects and also you can find out more details about the tools.



Technical Specification of Software:

Product Name
Stellar Repair for MS SQL
Version
9.0
Operating System
Windows 10 (32 bit/ 64 bit)
Windows 8.1/ 8 (32 bit/ 64 bit)
Windows 7 (32 bit/ 64 bit)
Windows Vista (32 bit/ 64 bit)
Windows Server 2012 / 2008
Supported SQL Versions
MS SQL Server 2017 & all prior versions
Memory
2 GB Minimum
Hard Disk
250 MB of Free Space


Features of Stellar Repair for MS SQL

Let’s check out the functionalities of the tool along with pictorial representation.
This is an example of a corrupted database in suspect mode, you can check your database status usingSELECT DATABASEPROPERTYEX('[Your Database Name]','status') AS Status

Database in Suspect Mode

If your database is in Suspect mode or Offline mode, or it may be the 'recovery pending' and database attachment issue there are various reasons for the same it may be a hardware problem like your hard disk crashed or that issue can be  a bug of SQL Server, Operating system malfunction that can be lead system to not function correctly, or it can be raised by  unexpected system shutdown while a transaction is ongoing, or by compromising your system by  virus attacks etc.

1)   Download and launch Stellar Repair for MS SQL

This is where we can start from the main interface of the software, an instruction popup will be appear at the main screen to inform you to make a copy of your database and try to repair that copy,


Stellar-Repair-for-MSSQL



this is the main screen, we can click on the button 'Select Database' to select the database and a pop up window will appear where you can browse your files. 

Stellar-Repair-for-MSSQL


2)   Select the target database that needs to be repaired

There are two ways to select the target database file, you have to select your corrupted database file by clicking on 'Select Database' or ‘Search' options. If you know the exact location of your target database then click on 'Select Database' option and select that file,

Stellar-Repair-For-MSSQL

or you can find the database in a particular folder by using 'Search' option to find (.MDF) file in a particular drive/location.


Stellar-Repair-for-MSSQL


there is an additional option that is 'Include Deleted Records' is an optional and useful one to recovers the deleted records, it also recovers the data from the objects.

3)   Now we are good to start the repairing process

Make sure you have selected the file which is needed to be repaired after that, you just need to click the 'Repair' button to start the repairing process.


By opting for 'Include Deleted Records' we may get deleted data from the selected MDF file.

Stellar-Repair-for-MSSQL

There is a log report window where you can see the progress of repair process, also if you have any recent attempt to recover then it will give you an option to resume the process from the saved repair information.

4)   The Message about activation of the product when we want to save the repaired database.

There will be a message pop-up on the screen. If you want to register the software then you'll need an activation key and follow the instruction, or if you just want to see the preview of the database before purchase to confirm your database recovered well then, you can preview that easily.
To activate the product you need to buy this product from their official website ( https://www.stellarinfo.com/sql-recovery.php )

Stellar Repair for MS SQL Activation window


5)   Preview of repaired database

This is a preview of the selected database after complete the repairing process successfully, Also, there is a search control you can directly reach out to the object instead of traverse one by one,

Stellar repair for MS SQL Preview of Recovered Database

by using that find button we can easily find the object on the left panel as shown below,


Stellar repair for MS SQL Find functionality

Stellar Repair for MS SQL will show you the Preview of corrupted database files. The left pane displays a list of items (Tables, Views, Synonyms, Defaults, Data Types, etc.) in that database file in a tree-like structure,



As I opted to ‘Include Deleted Records’ there are recovered deleted records from the database file, Click on the 'Save' to save the repaired database.

6)   Multiple Saving options

Stellar Repair for MS SQL provides multiple file format options to save the repaired SQL server database file, which includes MS SQL database files, CSV, HTML, and XLS. Providing the number of formats is helpful because you don't need to install MS SQL Server on your system for opening the repaired file as it can be export as in the other formats.


Stellar Repair for MS SQL - Multiple Saving options

saving as XLS format,


Saving as XLS

we can save that objects into these formats as shown below


Stellar Repair for MS SQL- Save as HTMLStellar Repair for MS SQL- Save as CSVStellar Repair for MS SQL- Save as XLS


As an advantage, it keeps the non-recovered queries in a separate text file of severely corrupt objects that are not recovered by this it is easier not to mess up with the recovered and not recovered objects, we can find them in a separate text file. 

7)   How do you want to save the repaired database 

There are two ways to save our repaired database file in 'New database' or 'Live database'. If you want to restore the repaired database to the ‘New Database’ then select the option for 'New Database' or If you want to restore the repaired database to the ‘Live Database’, select that option and you need to provide Server credentials details. 


Saving as default New Database

As i selected for new database as shown below the recovered database, there are 2 options that we can choose either we want to save that MDF file in the default SQL Server directory or we can choose to save a new location by choosing New option.

Stellar Repair for MS SQL - Recovered Database


Once it complete, click on the Connect button to proceed further, after this you can check your database status again by using  ‘SELECT DATABASEPROPERTYEX('[Your Database Name]','status') AS Status’

Ordering the Software
Click https://www.stellarinfo.com/sql-recovery.php to know more about Stellar Repair for MS SQL.
To purchase the software online, Please visit https://www.stellarinfo.com/sql-recovery.php



Note: This article is only for informational purpose. This is a free review of the product.



Post a Comment

5 Comments

  1. Replies
    1. You can use it free but you will be limited to Preview only if you want to save repaired file then you need to activate the software.

      Delete
    2. Hi, Nice Writeup! One can also read this to recover data from corrupted MDF files. Please refer this: https://dzone.com/articles/how-to-repair-mdf-file-in-sql-server-database

      Delete
  2. Thanks for sharing. I repaired MS SQL database using this software.

    ReplyDelete