Watch the working preview of software and simply follow the steps :
Install & run the SQL Database Recovery Software and click Open.
Select the corrupted MDF file and click Open
Click on Advance scan mode and click Auto Detect option if you dont know the version of SQL mdf file.
Or you have option to manually select SQL Server version.
Click on the second tab and click first radio button, if you dont know the NDF file.
You have option to manually choose NDF file or folder by clicking on Add File/Add Folder.
After selecting NDF file, Click Ok
Software will show the scanned report of recovered database files.
Software gives you option to save your recovered data in .str file. If you want to save the file, Click Yes
Choose the desired location to save the .str file and click Save
Preview recovered data of MDF & NDF file. The software will show you the preview of recovered functions, views, triggeres etc.
Click on Export to save your recovered data.
Software will give you two option to export recovered data. Either export to SQL Server Database or as .sql script.
Choose the Authentication mode.You can fetch SQL Server name by clicking on drop down button if you are using Windows Authentication mode.
You can manually enter Server name.
If you are using SQL Server Authentication mode, then enter SQL Server Name and Login credentials
You will get two option to save recovered data. Either save it in new database or save in existing database.
To save recovered data in new database, Click on Create database and provide new database name.
Software will display default collation type of your database.
Select the checkbox of database objects, you want to export.
Software will give you two option to export, Either export as 'With Schema' or as 'With Schema & Data'.Choose accordingly.
Click With Schema & Data, if you want to save the database components with both schema & data.
If you want to recover deleted records, then check on Export Deleted Records.
'Export Completed' window will pop up confirming the successful export of the database.
Software will show you the status of exported data.
Software will show you the status of exported data. Click Close.
Software will ask you to save recovered data to .csv file. Click on Yes, if you want to save exported data in csv file.
Browse the desired location to save recovered data in .csv file.
You can go to the location where you save the file and check it your exported data by opening it.
Check your recovered data in SQL Server by expanding the database.