Open SQL Recovery software: For that, you have to first go to the Start menu » Programs » SQL Recovery » SQL Recovery. This following initial screen of the software will display:
Select the damages or corrupted SQL Server MDF file. For this, you need to click on the Browsebutton. Software will display the following screen:
Browse the corrupt MDF file in the above screen and then click on the Open button.
Now select the Scan Mode and 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 repaired MDF file using demo version, you can Save the recovered file in .str format
Select the location for saving .str file
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:
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:
Export/Save the repaired MDF file: After choosing the required "Saving Option", click the Export/Save button to save the repaired MDF file
Select a folder for save the .sql 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:
You should click on Close button and then navigate the saving location for finding the recovered sql script file.