How to Repair an .Mdf File
Database files that are created using Microsoft SQL Server usually end with the ".MDF" file extension. MDF files are compatible with programs such as Microsoft Visual Studio and Microsoft System Center. If you cannot open an MDF file using one of these programs, the file must have gotten corrupted. You can repair corrupted MDF files by using third-party recovery tools such as "Recovery Toolbox for SQL Server," "Stellar Phoenix SQL Recovery" or "SQL Recovery Tool."
Other People Are Reading
Things You'll Need
- "Recovery Toolbox for SQL Server," "Stellar Phoenix SQL Recovery" or "SQL Recovery Tool"
Instructions
-
Recovery Toolbox for SQL Server
-
1
Download and install "Recovery Toolbox for SQL Server." (See Resources section.)
-
2
Open "Recovery Toolbox for SQL Server." To do so, click "Start," click "All Programs" and then click "Recovery Toolbox for SQL Server."
-
-
3
Use the "Open File" icon next to the "Source File Name" field to select the MDF file you want to repair.
-
4
Click "Next" to repair the MDF file. After repairing, specify a location to save the repaired MDF file.
Stellar Phoenix SQL Recovery
-
5
Download and install "Stellar Phoenix SQL Recovery." (See Resources section.)
-
6
Open "Stellar Phoenix SQL Recovery." To do so, click "Start," click "All Programs" and then click "Stellar Phoenix SQL Recovery."
-
7
Use the button labeled "Open MS SQL File" to select the MDF file that you want to repair.
-
8
Click the button labeled "Start Repair" to repair the MDF file.
SQL Recovery Tool
-
9
Download and install "SQL Recovery Tool." (See Resources section.)
-
10
Open "SQL Recovery Tool." To do so, click "Start," click "All Programs" and then click "SQL Recovery Tool."
-
11
Use the "Browse" button next to the "Select SQL Server (.mdf) File" field to select the MDF file that you want to repair.
-
12
Click "Recover" to repair the selected MDF file.
-
1
