Corrupted MDF files

ankit3302

3205 pts.

Tags:

.MDF files

corrupted files

MDF

SQL

SQL Server

SQL Server database

Can anyone help me with how to view corrupted mdf files? I have certain MDF files which have been corrupted and creating hindrance in accessing SQL server database. I want to view these files. So, just wanted to know how to view them?

Asked: November 29, 2018 12:09 PM Last updated: April 6, 2019 2:32 AM

Answer Wiki

Last updated: April 5, 2019 4:46 AM GMT

Shanabrobin15 pts.
History
Contributors
- Ordered by most recent
- Shanabrobin15 pts.
- Tom Curtin510 pts.
- ToddN2000123,845 pts.
- ankit33023,205 pts.

Thanks. We'll let you know when a new response is added.

You might want to try to repair them. Try reference1 and reference2

Discuss This Question: 2 Replies

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

Subhendu Sen Dec 4, 2018 7:24 AM GMT

Before you try the random tools, please make sure that you save a copy of the MDF file, so that you don't make things even worse. Next have you tried to query the database. Is the database marked suspect/ inaccessible? Or do you get an error when you try to query ? Please provide more information.

128,540 pointsBadges:

report
TheRealRaven Apr 6, 2019 2:32 AM GMT

Recovery from "corruption" depends on what parts of the file are corrupted, how extensive the corruption is, whether corruption is limited to data rather than hardware and other factors. Without details, little can be said about what should be done.

To start, how do you try to view the file and what happens when you try?

31,765 pointsBadges:

report