Start the SysInfo MDF Recovery Pro Tool as an administrator on your computer.
Click on the Open button to browse the SQL MDF file.
Click on the two options to add the MDF file:
Now, you have to choose the recovery mode as per your level of corruption, like Standard or Advanced.
You can also recover the deleted records and advanced deleted records by using these options.
Also, choose the collation option: either Auto Detects or Manual.
Select the Log File path where you want to save the log file. Click OK to start the scanning process.
Once the scanning process is completed, click on the OK button.
Select the folders, files, and subfolders that you want to restore. Here, you can also preview the specific table details.
Now, click on the Save SQL Data button to initiate the restoring process.
The opening tab contains two options to save MDF data: SQL Server Database or SQL Server Compatible SQL Scripts.
The software offers you two different options: Windows Authentication and Server Authentication.
First, we go for Windows Authentication. Here, you have to enter the Server Name and Database Name. Or, you can also save it in the existing database.
Please enable some other advanced features if required:
Click on the Test Database Connection button to check the Database connections as if it is working or not and you will find a pop-up displaying Database Connection established successfully. Click OK.
Secondly, we go for Server Authentication. Here, you have to enter the following details: User Name, Password, Server Name, and Database Name. Or, you can also save it in the existing database.
Click on the Test Database Connection to establish the proper connection with the server. Click Ok to start the restoring process.
Lastly, the saving process is completed. Click on the OK button.
Opt for the SQL Server Compatible SQL Script option and select the saving location for the output folder. Click OK to start the process.
Finally, the SQL script has been completed for the selected database. Click on the OK button.