How to Recover SQL Server Database

Open & Launch the SQL Server Recovery Manager Tool. Click Start » SQL Server Recovery Manager Tool » Launch SysTools SQL Server Recovery Manager Software.Click "Recover Data from Corrupt SQL Server Database".

Click on Open option to start the process of adding MDF file in application:

After clicking on the Browse button choose the MDF file and click on Open button to load the file on software.

Now You have two tabs (Quick Scan and Advance Scan)for recovering both MDF file as well as NDF Files.

Check the Auto detect option, if you want to detect the MDF file version automatically. You can also select the Server version of your MDF file manually.

User can choose Advance Scan for highly corrupted database files. Also check Recover Deleted Objects option to recover deleted database items.

Select the second tab i.e. NDF Options. Click Add Files option to recover the NDF Files. After adding file click on OK button:
Important Note: The NDF file must be associated with the MDF file i.e. Primary database.

Now select the detected NDF file i.e. secondary file of SQL server. Click Ok:

Software shows the summarized details of selected MDF files and the automatic scanning of the MDF files from SQL Server database take place.

You can also save the MDF file in .str file. If you want to save STR file then click on Yes otherwise click on No and move on to second step.

Select the location for saving .str file. Click Save:

Preview recovered database of MDF and NDF files: software will show the entire database of repaired MDF and NDF files such as tables, triggers, stored procedures and views etc.
User can also preview the deleted database components like Tables, Views, Stored Procedures, Functions, etc.

Now you need to click on Export button to export the recovered database:

You can export the recovered database as MDF, SQL Server compatible scripts and CSV. Choose the saving option among: SQL Server Database, SQL Server compatible scripts, and CSV File Format.

Software will fetch the available Server names by clicking on drop down arrow. If you are using Windows Server Authentication then no need to provide User Name & Password.

Choose Create New Database option to export repaired data on it and choose Export to Existing Database option to the repair data on an existing database.

Choose desired database components to export and check the Recovered Deleted Objects box to export the deleted objects like Tables, Views, Functions, Stored Procedures, etc.

The .sql file will get created if you export & save the file as SQL Server Compatible SQL Script mode.

Now check the desired component of database to export.

Choose from option either you want to export the MDF file with only schema or with schema & Data.

You can check the Export Deleted Objects if you want deleted records and other database objects to be exported and click on Save for export process.

Browse location for saving SQL file. Click OK:

After the completion of the recovery process, software will prompts the completion process as follows. Click Close:

Click Close when export process is complete.

If you want to save recovered data into .csv file then choose CSV File Format option.

Now check the desired database tables to export.

Choose from option either you want to export the MDF file with only schema or with schema & Data.

You can check the Export Deleted Objects if you want deleted Records and Database Tables to be exported and click on Save for export process.

Browse location for saving CSV file. And click OK:

After the completion of the process, software will prompts the completion process as follows. Click OK:

Click Close when the process is completed.

Navigate the Location where you saved recovered SQL Server Database.