I have got a corrupted mdf which needs to be repaired.  Does anyone has got a solution, please.

• Moved by Alan_chen Tuesday, January 31, 2012 1:21 AM (From:LINQ to SQL)

Red gate has a utility called rescue as I remember and now they provide it for free. Check that out:

http://www.red-gate.com/products/dba/sql-log-rescue/

Hi pijiewewe,

At first, back up the .mdf/.ndf Files.

Can you attach the database? If you cannot attach the database, please post the error messages.  There could be two solutions. You could refer to this blog: http://blog.sqlauthority.com/2008/07/21/sql-server-fix-error-9004-an-error-occurred-while-processing-the-log-for-database-if-possible-restore-from-backup-if-a-backup-is-not-available-it-might-be-necessary-to-rebuild-the-log/.

If you could attach the database, you could run DBCC CHECKDB. If there are still errors, run it again with  REPAIR_ALLOW_DATA_LOSS , the command means: data will be lost.

Thanks,
Maggie

check this thread

http://www.sqlrecoverytool.com/

http://www.sqlserverrecovery.org/

• Proposed as answer by vr.babu Thursday, February 02, 2012 10:00 AM

check this thread

http://www.sqlrecoverytool.com/

http://www.sqlserverrecovery.org/

it the best tool 

I have seen, most of the Expert database administrators suggest MS Gold Partner's Product Stellar Phoenix SQL recovery. It repairs .mdf & .ndf files and supports SQL server 2008 R2, 2008, 2005 & 2000.

Free demo version is available @ http://www.stellarsqldatabaserecovery.com/download-sql-database-recovery-software.php

Note: Free demo version shows the preview of corrupt database

The one I suggested is for 2000, not a demo but full working version and for free.

Dear Friend,

The MDF files of SQL database may get corrupt due to some problem in the database. If such a situation arises, the user can use the software which recovers the lost MDF file. But before choosing the software, make sure that it is efficient enough to recover the unique keys, primary keys, indexes, stored procedures, views etc from your corrupt MDF file.you can tryKernel for SQL Data Recovery .

For more You can visit here....http://www.sqldatabaserepair.net

• Edited by PaulJasper Monday, June 18, 2012 10:33 AM

Yes, there is a proficient solution that can repair your corrupt MDF file for MS SQL 2000. The tool named as SQL MDF Data Recovery provides you this facility which is widely accepted solution for many of the users to recover SQL database and extract database for utilization. Go through this site and solve your problem: http://www.sqlrecoverytool.com/recover-corrupt-sql-2000-database.html

I suggest using  SQL Recovery tool from ApexSQL and accomplish this in just a couple of clicks. It has a recovery option called 'Recover from a corrupted database or a detached MDF file'. This allows you to recover all of the tables and data using detached database data files

It is very difficult to repair and restore the data from MS SQL server after damage or corruption of the database. For such situation updated backups can be helpful, but when the backup data itself gets corrupted then the only option remains is the use of utility software SQL file Repair tool. This tool efficiently scans the damaged and corrupted database files and repairs them and lets you get access to the objects in MDF database files.

To find an efficient and secure SQL file Repair tool see for http://sqlmdf.filerepairtool.net