locked
How to recover data from mdf file?? RRS feed

  • Question

  • User-394508673 posted

    Hi all, if we overwrite the db backup(using restore database) then is it posible to recover data of previous backups???

    Monday, March 1, 2010 2:02 AM

All replies

  • User2039959148 posted

    yeah it is posible

    Thanks

    Fawad Ashfaq


    Monday, March 1, 2010 5:55 AM
  • User-394508673 posted

    gud ans. i got it :p u know nothing!!!

    thx for replying

    Monday, March 1, 2010 6:36 AM
  • User-169434202 posted

    Hi AhmadRock

    1) Try to repair the database with DBCC CHECKDB Commands. I suggest you to read Microsoft article on database recovery to understand how you can repair that corrupt MDF Database, but keep in mind to choose wisely between various syntaxes (REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD) as there is fair chances of some potential data loss and you need to make decision whether you are ready for that and if yes, then to what extent.

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

    2) There is another alternative and I suggest you to take into consideration. There are many SQL Data recovery software in the market that perform more or less the same, but have a fairly better probability of full database retrieval from corrupt database. There is one nice wiki article and if you decide to choose this alternative then go through all the steps mentioned over there and if you follow those every steps correctly then hopefully you will be able to retrieve fully your database

    http://www.wikihow.com/Perform-MS-SQL-Database-Recovery-Through-Software

    Hopefully if you try one or all of the methods you will be able to recover your database.

    Regards
    dimeshwilliam

    Wednesday, December 25, 2013 11:16 AM
  • User-1989583403 posted

    To recover data from corrupted MDF file, I can recommend you SysInfoTools MS SQL Database Recovery tool here. This tool scans corrupted SQL database (MDF) file and recovers maximum possible data from it. It saves your recovered data in either SQL database or SQL Scripts form. It supports MDF files MS SQL Server 2000, 2005 and 2008. 

    Before buying this software, you must check its free demo version. It will show the preview of recovered data before actual recovery. 

    To read more about this software and to downlaod its free demo version, visit: http://www.sysinfotools.com/ms-sql-database-recovery.html

    Thanks. 

    Wednesday, February 12, 2014 7:29 AM