Post reply

How To Recover Data From A Corrupt Mdf File?

  • September 22, 2014 at 6:10 am

    #290940

    Hi All,

    By mistake i delete database from sql server. Due to which the the mdf and ldf file of the datbase are removed from my system. Then i used file recover utility and retrived my mdf and ldf files.But now i am not able to attach those files into databse. These mdf and ldf files has been corrupted. Now how can i recover my data from those mdf and ldf files.Please answer me if you have any solution on this problem.

  • September 22, 2014 at 6:24 am

    #1747026

    Error messages please. Every single message, plus anything that's in the error logs.

    I don't think I've ever seen a case where SQL database files were recovered after deletion and were usable. To be honest, just restore from your last good backup. It'll be faster than trying to recover from the deleted files.

    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

  • September 22, 2014 at 6:58 am

    #1747053

    I agree that restoring from your most recent backup(s) would be the fastest way at this point. Do you have recent backups?


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • January 17, 2017 at 12:25 am

    This was removed by the editor as SPAM

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

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