View Data from SQL Server Database (.mdf and .ndf) Files

Open & Launch the SQL Server Recovery Manager. Click "View Data From SQL Server Database".

Now MDF Viewer screen of SQL Recovery Manager will appear. Click Open.

Select the MDF file to be opened.

Scan Modes

Select the scan options provided for both MDF and NDF files according to corruption scenario:

• Quick Scan for minor corruption in MDF file.
• Advance Scan for major corruption in MDF file. Also check Recover Deleted Objects option, if you want to view deleted Table Records, Tables, Stored Procedures, Functions, etc.

Click Auto detect option if the SQL Server version is not known.

Select an appropriate SQL Server database version if you know the Database file version. Note that, selecting the wrong version may result in inconsistency.

In NDF Options you can choose the SQL Server secondary database .ndf file.

• Select Auto detect option, if NDF file location is not known to you.
• Click Add File/Folder option to manually load NDF File in multiple or in bulk form, click Ok.

Now view the live scanning process.

A pop up will appear on screen once the scanning ends with the message: Do you want to save the scanned file?
Click on Yes to save, otherwise click No.

Now name the scanned MDF file to be saved in .str format.

Your scanned file is saved successfully. Click Ok.

Preview Recovered MDF Database

Preview the entire contents of repaired MDF and NDF file: tables, triggers, stored procedures, and views etc. Users can also preview all the deleted database components like: Tables, Functions, Views, Stored Procedure, etc.