Client Management Suite

 View Only
  • 1.  one of .mdf is non valid

    Posted Apr 25, 2017 06:33 AM

    I have many dozens .mdf files on my HDD working via SQL Server 2014. One of them viewed an error some days ago - The header for file SQL903.mdf is not a valid database file header. I only want to find a solution to repair sql server database.



  • 2.  RE: one of .mdf is non valid

    Posted Apr 25, 2017 07:30 AM

    Hi Melissa,


    This doesn't appear to be a Client Management Suite issue, and rather a Microsoft issue.

    Check below:

    https://social.msdn.microsoft.com/Forums/en-US/be7db99a-5e3f-414d-a9e0-d45f99d2928b/corruption-mdf-header-corrupted?forum=sqldatabaseengine

    Thanks!



  • 3.  RE: one of .mdf is non valid

    Posted Apr 28, 2017 12:14 PM

    When you work with sql database during some months and after it becomes invalid. I’m sure every man will waste all the free time for searching reliable solution. I find it in https://www.repairtoolbox.com/sqlserverrepair.html Because even its demo version showed all the features of it



  • 4.  RE: one of .mdf is non valid

    Posted Apr 28, 2022 05:41 AM
    You can use the third-party SysCurve SQL Repair tool to fix MDF and NDF files. I find this https://www.syscurve.com/sql-recovery-tool.html. I hope this will work for you.