Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Repair MDF Files

- - - - - repair MDF files

  • Please log in to reply

#1
shripriya

shripriya

    New Member

  • Member
  • Pip
  • 4 posts

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


  • 0

Advertisements


#2
kimberleyprice78

kimberleyprice78

    New Member

  • Member
  • Pip
  • 1 posts

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.


  • 0

#3
shripriya

shripriya

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts

Thanks for the solution kimberleyprice.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP