Know How to Repair MDF File Using MS SQL Repair Tool
First open the software. For this, you need to go to the Start menu » Programs » SQL Recovery » MS SQL Repair. Initial software screen will appear as displayed below:
Select the damages or corrupted SQL Server MDF file. For this, you need to click on the Open button. Software will display the following screen:
Browse the corrupt MDF file in the above screen and then click on the Open button.
Now choose the scan mode and select SQL Server version
Have an NDF File: Click on NDF Option and Choose Add Files option
Choose damaged or corrupted NDF File and click on Open button
After this procedure software will automatically scan your selected MDF/NDF file
After Complete the scanning process, you can Save the repaired file in .str format
Choose the saving location
Preview the recovered content from the repaired MDF file. Software will show you all the recovered elements from the repaired MDF file like its tables, views, stored procedures etc as follows:
Now, you click on the Export Button
Choose the Saving Option. You have to choose one option between the two saving options provided by SQL recovery software. The two options are as follows:
- SQL Server Database: On choosing this option, software will save the repaired MDF file in existing SQL database. In this option, you need to give the database credentials like Server Name, Database Name, Username, Password and then select the tables, views procedure to be saved from the left-bottom pane. At last, click on the Export/Save button.
- SQL Server Compatible SQL Scripts: On choosing this option, software will save all SQL scripts in a specific folder. You need to select the tables, views procedure to be saved from the left-bottom pane. At last, click on the Export/Save button.
After choosing the required "Saving Option", click the Export/Save button to save the repaired MDF file
Select a location for save the .mdf files
Export as SQL server compatible SQL script, after the completion of the recovery process, software will prompt users regarding the completion process as follows: