I am unable to access the MDF file. Can anybody suggest the method to repair MDF files?
Repair MDF Files
Posted 05 January 2019 - 04:15 AM
Posted 22 January 2019 - 04:51 AM
MDF file is the most important file of SQL database. To repair corrupted MDF files by these ways:
- 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)
- 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.
Posted 24 January 2019 - 06:19 AM
Thanks for the solution kimberleyprice.
Posted 22 October 2020 - 09:58 AM
Redundant thread closed to prevent any further spam posts.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users