I am unable to access the MDF file. Can anybody suggest the method to repair MDF files?
Repair MDF Filesrepair MDF files
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 Yesterday, 01:42 AM
If you wish to repair and restore MDF Files, you can Read:
There are many reasons for corrupt MDF Files. Some of the reasons are:
- Unexpected changes in SQL Server accounts
- Accidental data deletion from the SQL database
- Corruption in the header part of the database
- Storage media corruption where SQL database file is stored
So, read the post to know the best methods to restore the files.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users