Know How to Open and View SQL Server Database MDF File

Simple Steps to Know How to View Inaccessible or Corupted SQL Server Database MDF File

STEP 1

Go to Start » All Programs » SysTools MDF Viewer

mdf viewer pro
STEP 2

From the software menu, Click on “Open” to browse and open the desired MDF file from its location:

browse mdf file
STEP 3

Now Choose The Scan Mode

Select the Option from Quick Scan and Advanced Scan. The user can check Quick Scan option for normal corruption of database, for major level of corruption the user can select Advanced Scan. Also Choose the version of SQL Server, if you dont know the version Just click on Auto detect SQL Server .mdf file version.

select scan option
STEP 4

Mark the Option Preview deleted records checkbox to preview permanently deleted table records in Red color.

preview deleted records
STEP 5

Scanning Process of MDF File

The MDF Viewer Software will display the scanning report after performing Quick Scan operation on MDF File.

scanning report
STEP 6

Software will prompt a note for Quick Scan results and recommend to use Advance scan if the expected results not found by Quick Scan. Click Ok to preview SQL database items.

scan options
STEP 7

MDF Viewer Software Will Preview the database objects such as Table, Views, Stored procedure, Rules, Triggers, Functions etc.

preview database objects

Also the user can preview Unicode Data data type by using this Software.

preview unicode data

The User Can Preview Unicode Stored Procedure.

preview stored procedure

Also User Can Preview Unicode Rules By Using This software.

preview unicode rules

Download MDF Viewer Software Download Now