Post reply

Recover from corrupt MDF or BAK

  • November 26, 2003 at 5:00 am

    #160923

    I everyone

    anyone experienced a recover from a corrupted MDF File or BAK File ?

    I've a MDF and BAK file got from a break RAID 5 volume. The file are consistent, by dimension and MFT entries, but is not SQLServer READABLE. Is it possible to "load" anything READABLE is in the file not minding of qhat is not READABLE or SQLServer structured ???

    Thanks

  • November 26, 2003 at 5:44 am

    #483703

    To the best of my knowledge the answer is no. I also know of no tool to correct a broken file.

  • November 26, 2003 at 7:12 am

    #483728

    quote:

    To the best of my knowledge the answer is no. I also know of no tool to correct a broken file.

    Even i can open (in HEX) the backup file and verify the data is inside ???

    I think is just a matter of structure of bak file.

    Anyway .. thanks a lot

  • November 26, 2003 at 7:21 am

    #483730

    I once tried to bring a db back to life I intentionally corrupted. I didn't succeed. If you manage to edit it properly in a hex editor, please post again.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    Edited by - Frank kalis on 11/26/2003 07:21:26 AM

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 26, 2003 at 8:01 am

    #483749

    Have you tried an "Emergency" mode recovery?

    http://www.tek-tips.com/gfaqs.cfm/pid/962/fid/4210

    Failing that, are you in any of the Microsoft Partner programs (or anything else that gives you an allotment of help calls)?

    One of my colleagues once brought a very important db back from the dead (this had been corrupted by a RAID failure BTW) with some exceptionally knowledgable help from Microsoft Support.

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

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