Download the DRS SQL Recovery Tool and install it. Then, run it as an administrator.
Now, click Open to add the corrupted MDF file.
After that, press the Browse button to choose the corrupted MDF file.
From the file explorer wizard, locate the desired MDF file and click on the OK button.
Select the Recovery mode from the drop-down Opt for the Standard mode for less corrupted files and Advance mode for heavily corrupted files.
Next, mark the SQL 2000 option if you are using a backup file of SQL 2000. Otherwise, leave it.
The Show deleted records and show Advanced Deleted records option allows you to recover recently deleted tables. Opt this option as per your requirement.
In the Collation section, choose Auto-detect if you do not know the collation of the selected file. Otherwise, opt for the Manual option for manually specifying the file collation.
Then, select your desired Log files path and press the Ok button.
Wait for a while until the scanning process is over.
After scanning, you will see the database items in the left pane as a tree-structure. Select the desired items and click on the Save button.
Next, in the saving wizard, opt for the SQL Server Database option.
You will see options: Windows Authentication and Server Authentication. Opt for the Server Authentication option and enter the required username and password.
Now, choose from Export with Schema and data, Export with only Schema, and Do not save table constraints option.
At last, click on the OK button to save the recovered data.
After successfully saving the data, a pop up appears. Click OK to close it.