Start the DatabaseFileRecovery SQL Database Recovery Tool as an administrator on your computer.
Click on the Open button to browse the SQL database files.
We can add the MS SQL database files (MDF & NDF) in the utility wizard.
Select the recovery mode from the drop-down list, either Standard or Advanced.
You can also manage your deleted records, or there is also an option to preview the advanced deleted documents.
Select the Collation option: Auto-Detect or Manual as per your requirements.
After that allocate the directory path for the log file. Click Ok to start scanning.
The software displays you a pop-up: Scanning process completed, click Ok.
A tree structure gets loaded on the software wizard at the left panel. Here select the folders you want to restore. You can also preview specific table details.
Click on the Save SQL Data button to initiate the restoring process.
The opening tab contains two options to save MS SQL 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 this button to check whether the Database connection 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, and click on the OK button.