[shripriya]

I am unable to access the MDF file. Can anybody suggest the method to repair MDF files?

[Advertisements]

MDF file is the most important file of SQL database. To repair corrupted MDF files by these ways:

1. Execute the DBCC CHECKDB command

DBCC CHECKDB (Name_of _corrupt _database)

 

Case 1: If index ID > 1, drop it and create it again.

 

Case 2: If index ID is either 0 or 1, then run DBCC CHECKDB again with the repair options

DBCC CHECK (name_of_corrupt_database, repair_fast)

DBCC CHECK (name_of_corrupt_database, repair_rebuild)

DBCC CHECK (name_of_corrupt_database, repair_allow_data_loss)

 

1. Restoring MDF file from a recent backup

If these methods get fail to revive a damaged MDF file, then try professional tools which are more helpful to repair SQL database file. After gone through to SQL database communities like Stack Overflow, SQL Central and many more. There are many tools provided like Stellar Repair for MS SQL software, ProMX, Saloniris. If you want to try more methods then search on Microsoft Technet Forum and try other methods also.

[kimberleyprice78]

MDF file is the most important file of SQL database. To repair corrupted MDF files by these ways:

1. Execute the DBCC CHECKDB command

DBCC CHECKDB (Name_of _corrupt _database)

 

Case 1: If index ID > 1, drop it and create it again.

 

Case 2: If index ID is either 0 or 1, then run DBCC CHECKDB again with the repair options

DBCC CHECK (name_of_corrupt_database, repair_fast)

DBCC CHECK (name_of_corrupt_database, repair_rebuild)

DBCC CHECK (name_of_corrupt_database, repair_allow_data_loss)

 

1. Restoring MDF file from a recent backup

If these methods get fail to revive a damaged MDF file, then try professional tools which are more helpful to repair SQL database file. After gone through to SQL database communities like Stack Overflow, SQL Central and many more. There are many tools provided like Stellar Repair for MS SQL software, ProMX, Saloniris. If you want to try more methods then search on Microsoft Technet Forum and try other methods also.

[shripriya]

Thanks for the solution kimberleyprice.

[phillpower2]

Redundant thread closed to prevent any further spam posts.