locked
free MS tools for recovery of corrupted MDF, LDF, and SQL backup files.

    Question

  • looking for free MS tools for recovery of corrupted MDF, LDF, and SQL backup files.

    We have a situation where we have corruption of data as the result of punctures which have occur on our SQL server.

    MDF, LDF, and SQL backup files are partly corrupted so that some free recovery tools we have resulted in failures.

    Are there any recommended MS tools for this kind of recovery for SQL. 

    we want to recover some of the data if possible


    dsk

    Wednesday, January 20, 2016 9:23 PM

Answers

All replies

  • What are 'Punctures' in SQL server ?  What does that mean?

    Is the database already attached to SQL Server ?  Try

    DBCC CHECKDB('dbname', REPAIR_FAST)

    If that fails, try 

    DBCC CHECKDB('dbname', REPAIR_REBUILD)

    If that fails, finally try

    DBCC CHECKDB('dbname', REPAIR_ALLOW_DATA_LOSS)

    If that fails, call MS.


    -- Paul Wehland (MCM-SQL) Avanade GmbH

    Wednesday, January 20, 2016 9:36 PM
  • Hi There,

    There are some third party tools available in the market to remove the corruption from the Databases. You need to pay the license costs.

    First figure out where the corruption happened then try to fix the issue.

    some useful links below for third party tools.

    http://www.stellarinfo.com/sql-recovery.php

    thanks

    kumar

    Wednesday, January 20, 2016 10:44 PM
  • Refer to the below article available in TechNet, it contains a Trail version as well or else you can try with DBCC to fix the corruption.

    https://gallery.technet.microsoft.com/How-to-Repair-Corrupt-SQL-78780e33


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Thursday, January 21, 2016 5:09 AM
  • Hi, kimdav111

    When a MDF database file is corrupt, you can first use the SQL Server build-in command DBCC CheckDB and CheckTable to repair it, see:

    http://technet.microsoft.com/en-us/library/ms176064.aspx

    and

    http://technet.microsoft.com/en-us/library/ms174338(v=sql.110).aspx

    to get more information about the commands. This is the recommended solution which you should try first.

    If the corruption is severe and the above commands do not work, then you may try some third party tools to scan and recover the data from your corrupted MDF and NDF database files. Below is a list of SQL recovery tools:

    https://www.datanumen.com/sql-recovery/compare.htm

    The list seems to rather comprehensive that including nearly all the popular tools in the market. And all the tools provide a free demo so you can try before you purchase.

    Hope this will help. Good luck!
    Friday, January 22, 2016 9:09 AM
  • Personally I would NEVER rely or user 3rd party tools and why I ensure that regular and validated point in time Backups are taken, tested and retained offsite.

    Feel free to attempt Paul's suggestion for repairing but PLEASE:

    1. Understand EXACTLY what each option does before running otherwise you could (and no doubt will) end up losing data.
    2. Before attempting a repair TAKE A BACKUP
    3. Attempt the repair on a restored copy of your corrupted databases
    4. Be careful
    5. Learn from this situation and avoid letting it happen again

    As a DBA (assuming you are) you are the guardian of your companies data and the responsibility for avoiding data loss is yours.

     

    Regards,
    Mark Broadbent.
    Microsoft Certified Master | Microsoft Data Platform MVP
    Contact me through twitter | blog | sqlcloud


    Please click "Propose as answer" if a post solves your problem
    or/and vote the post up if it's been helpful.

    Interested in attending a free training? Why not attend SQLSaturday Cambridge and SharePoint Saturday Cambridge? And why not check out my Ultimate Training Resources Page?

    Friday, January 22, 2016 11:37 AM
  • Firstly, you should try this procedure to repair

    • Stop SQL Server instance
    • Copy MDF and LDF files to another location
    • Delete original MDF and LDF files
    • Start SQL Server instance again
    • Create a new database with the exact same name and file names
    • Stop SQL Server
    • Overwrite newly created MDF and LDF.

    If the above given steps successfully recovers your database, then you should be good if not, then you can use third party tool like http://www.sqlmdfviewer.org/recovery/

    Thursday, February 18, 2016 11:55 AM