Post reply

MDF file header corruption

  • August 10, 2012 at 7:33 pm

    #265813

    Hi All,

    Is there any way if mdf file header is corrupted. Can we extracted data from it. Is there any workaround to pull out data,.

    Had it been a log file header corruption at least we can rebuilt the log. But i see a mdf itself is corrupted and there is no backups available of one my clients. I dont knw how they are maintaining those database. The database size is 45 Gigs. There are in RTM sql 2005. Its nasty.

    Out of my curosity, i just wanted to know is there any any way can we fetch data and load it a temp database atleast.

    Error: 5172, Severity: 16, State: 15.

    The header for file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dbname.mdf' is not a valid database file header. The PageAudit property is incorrect.

    Any suggestions will be great help.

    Thanks in Advance.

  • August 11, 2012 at 3:13 am

    #1524751

    That one's fatal, not repairable in any way and there's no way to get that DB open.

    You can try buying a 3rd party data recovery tool and hope that they live up to their promise (many don't)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 11, 2012 at 11:09 am

    #1524790

    Thanks Gail.

  • August 14, 2012 at 12:28 am

    This was removed by the editor as SPAM

  • August 31, 2012 at 3:19 am

    #1532264

    Hi,

    you can recover your MDF File with the help of a third party data recovery software there so many you can choose one of them

    Kernel for SQL Databse

    Recoveryfix for SQL Database

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply