Post reply

Extract .mdf from .bak in SQL Server 2005

  • March 26, 2015 at 2:43 am

    #1786478

    The ldf file isn't in the backup. All that's in the backup is the data and what was the active portion of the log at the time of backup. If the backup failed part way through, it likely won't be restorable (it's not like a zip file containing the files separately)

    What error do you get if you try to restore the backup? Use T-SQL not the GUI and the CONTINUE_AFTER_ERROR option.

    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

  • March 26, 2015 at 1:14 pm

    #1786667

    Please try:

    MDF Repair Kit. An exciting new product from Repair Kit, this MS SQL MDF repair tool is an absolutely indispensable tool for anyone who wants to know how to repair MDF files in minutes. The program is based on a powerful analysis core and uses a convenient wizard-driven UI.

    For more: http://www.mdf.repair/%5B/url%5D

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

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