Skip to main content
Participant
February 3, 2014
Question

How do I repair damaged sql server mdf file database?

  • February 3, 2014
  • 5 replies
  • 2860 views

In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

    This topic has been closed for replies.

    5 replies

    February 11, 2014

    Restore the .MDF file from the backup, if you have any!

    If no backup is there, you need to use a commercialware MDF repair or recovery utility. If you search about such utility on Google, you shall get a wide range of software companies who provide such repair or recovery software. You can try any of them. Most of them are available with free demo version.

    Or if you are looking for a recommendation, I can recommend you to try demo version of SysInfoTools MS SQL Database Recovery. This tool will repair your corrupted MDF files and recover you data from them. Try it.

    To know more about this tool and to download its free demo version, visit: http://www.sysinfotools.com/recovery/ms-sql-database-recovery.html

    Thanks.

    February 5, 2014

    You can repair your damaged .mdf file using Kenel for SQL Recovery Tool. It is so proficient & smartly programmed application to restore your data from corrupt MDF files. Go to http://www.sqlrepair.org to know more about SQL Server Recovery and download the demo application.

    February 5, 2014

    First thing first, It is not the Microsoft forum so I will suggest you to ask your question on Microsoft forum.

    What is the error message after running DBCC CHECKDB against the database?

    It is hard to reply without any proper error message. Have you tried restoring corrupt database from Backup?

    In the mean time you can get help from 3rd party SQL repair program to repair your database.

    February 3, 2014

    I suggest you to take help from this article http://www.wikihow.com/Analyze-SQL-Server-Log-Transaction-(LDF-File)-and-Recover-Corrupt-SQL-Data-with-SysTools-SQL-Log-Analyzer  which will help you to recover corrupt sql database.

    February 3, 2014

    Are you looking out for a right solution to recover damaged database of SQL Server MDF files, then using SQL recovery tool is an effective MDF file recovery solution that enables user to repair and recover corrupt SQL database in just few minutes. To know more: http://www.repair-sql.net/