Live Chat

PCDOTS® Free MDF File Viewer

Excellent · Trusted by IT teams in 120+ countries since 2005

Free MDF File Viewer
to Open SQL Database Files

Free Download100% Free · 100% Secure Upgrade to Pro

Opens MDF files directly on your Windows PC with no SQL Server installation needed. It reads healthy and corrupt SQL Server database (MDF and NDF) files and shows every table, record and object in a clean preview. Completely free.

  • Opens MDF files without SQL Server or SSMS installed
  • Views tables, views, stored procedures, triggers and keys with row counts
  • Reads corrupt and healthy files from SQL Server 2000 to 2025
PCDOTS
Free MDF
File Viewer
SQL SERVER 2000–2025⊞ Windows 11
Opens the files SQL Server cannot No SQL Server installed Corrupt or damaged MDF Database marked SUSPECT Orphaned MDF from an old server NDF secondary data files Deleted records inside the file

When to Use PCDOTS Free MDF File Viewer

Three jobs bring most people here. All three take minutes with the viewer and none of them need a SQL Server installation.

Look inside an old MDF file

An .mdf turned up on a backup drive, a retired server or a client handover and you need to know what is in it. Open it directly and browse every table without building a server first.

See how to open an MDF file

Check a corrupt file before repair

The database will not attach and you need to know what survived before spending money or hours on recovery. The viewer shows the readable contents free, so you decide with facts.

See corrupt file viewing

Confirm deleted data still exists

Rows vanished after a DELETE command and you want proof they are still inside the file before choosing a recovery path. Deleted records appear right in the free preview.

See deleted record viewing

Key Features of the Free MDF Viewer

Everything You Need to Look Inside an MDF

Open MDF Files Without SQL Server

The viewer opens SQL Server database files directly on any Windows PC, with no SQL Server instance and no SSMS installation required. Point it at an .mdf file from a backup drive, an old machine or a client handover and browse the contents in minutes. NDF secondary data files load alongside the primary file automatically.

View Corrupt and Damaged MDF Files

A file that SQL Server refuses to attach can still be read. The viewer scans the file page by page, so it opens corrupt, SUSPECT marked and orphaned MDF files and shows you everything that survived. That makes it a fast free way to check what is recoverable before you decide on repair. If you then need the data back, the SQL database recovery software exports it.

Complete Object Tree with Row Counts

Every object appears in a tree on the left pane the way SSMS shows them: tables, views, synonyms and programmability. Each table lists its row count and empty tables are flagged, so you spot missing data at a glance. Select any object and its contents appear in the right pane with page wise navigation through large tables.

Search and Filter Any Record

Find one row inside millions in seconds. Search the data with Match Case and Whole Word options, filter individual columns and apply or clear filters in one click. It works across every table in the file, which turns the viewer into a practical lookup tool for audits and quick checks.

View Deleted Records

Tick Include deleted records and rows removed from tables appear in the preview alongside live data, with a filter to show deleted tables and records on their own. It is a free way to confirm whether data lost to a DELETE command still exists inside the file before deciding on recovery.

Auto Version Detection, 2000 to 2025

The viewer reads the SQL Server version straight from the file header, from SQL Server 2000 through 2025 including Express editions. You never need to know which version created the file or match it to an installed server, because there is no server involved at all.

Open and Read an MDF File in 3 Simple Steps

No configuration, no connection strings and no server. Open the file and start reading.

STEP 1

Select the MDF file

Click Select Database and pick the .mdf file. The viewer detects the SQL Server version automatically from the file header.

NDF files load alongside
STEP 2

Let the viewer read the file

The engine reads the file page by page, including damaged regions of corrupt files. The log shows tables found in real time.

Original file stays read only
STEP 3

Browse, search and inspect

Explore the object tree, open any table, search records and view deleted rows. Everything on screen is free to read.

Row counts on every table

For Files You Need Back, Not Just Viewed

The viewer shows you what is inside. When you need the data out, move to MDF Viewer Pro and export everything to a live SQL Server or as .sql scripts and CSV, deleted records included. And for files too damaged for any software, expert repair engineers take over with a free analysis.

Upgrade to Pro

MDF Viewer Specifications and Supported Versions

Everything the free viewer supports, in one place. No license, no signup and no server dependencies.

CostFree. Open, browse and search unlimited MDF files with no license or signup.
File typesSQL Server primary data files (.mdf) with secondary data files (.ndf) loaded alongside.
Supported SQL Server2025, 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000, including Express editions. Version is auto detected from the file.
What you can viewTables with records and row counts, views, stored procedures, functions, triggers, indexes, keys and deleted records where they survive in the file. Unicode and international character data displays correctly.
Supported WindowsWindows 11, 10, 8 and 7. Run as Administrator for protected file locations. No SQL Server or SSMS required and the viewer works completely offline, with no internet connection or registration needed.
Product resourcesSupport center · All PCDOTS tools · EULA and terms

MDF Viewer Free Version or MDF Viewer Pro

MDF Viewer answers the question what is inside my file. MDF Viewer Pro gets the data back out. Both read the same files the same way.

CapabilityMDF Viewer (Free)MDF Viewer Pro (Paid)
Open MDF and NDF files without SQL Server
Read corrupt and SUSPECT marked files
Browse the full object tree with row counts
Search and filter records
View deleted records
Export to a live SQL Server database—
Export as .sql scripts and CSV—
Restore deleted records to a working database—
CostFREESee current price
Free Download Upgrade to Pro
Since 2005
Building recovery tools for IT teams
120+
Countries served worldwide
10M+
Downloads across PCDOTS tools
Free
Unlimited files, unlimited viewing

What People Open with the Free MDF Viewer

Three recent uses shared with permission. Company names withheld for confidentiality.

CASE · OLD SERVER · 2008 MDF ★★★★★
"A client handed us a 2008 era MDF from a decommissioned server and asked what was in it. No way I was building a SQL 2008 instance for that. The viewer opened it in two minutes and I sent them a table list the same morning."
Daniel R. IT Consultant · Toronto
CASE · CORRUPT FILE · PRE REPAIR CHECK ★★★★★
"Our database went suspect and management wanted answers before approving anything. The free viewer showed the tables were readable, so we bought the recovery tool knowing exactly what we would get back. No gamble involved."
Meera S. Database Administrator · Pune
CASE · DELETED ROWS · VERIFICATION ★★★★★
"An intern ran a DELETE on the wrong table. Before escalating I opened the file in the viewer, ticked deleted records and there they were, all 4,000 rows still in the file. That screenshot made the recovery decision easy."
Thomas B. Systems Engineer · Hamburg

Common Questions About Opening MDF Files

The questions we hear most. Anything else, ask on live chat. A human answers.

01How do I open an MDF file without SQL Server?
Open an MDF file without SQL Server by using a standalone MDF viewer that reads the file directly from disk. The whole process takes three steps:
  1. Download and install the free PCDOTS MDF Viewer on any Windows PC.
  2. Click Select Database and pick the .mdf file. The SQL Server version is detected automatically.
  3. Browse the object tree and open any table to read its records.

No SQL Server instance, no SSMS and no attach step are involved at any point.

02What is an MDF file?
An MDF file is the primary data file of a Microsoft SQL Server database. It stores the actual database contents: tables with their records, views, stored procedures, functions, triggers, indexes and keys. Windows has no built in program that opens it, which is why double clicking an .mdf does nothing. A database can also have secondary data files (.ndf) and a transaction log (.ldf) alongside the MDF. On a typical installation, SQL Server keeps the file in the DATA folder of the instance under C:\Program Files\Microsoft SQL Server.
.mdfPrimary data file, the tables and records this viewer opens .ndfOptional secondary data file, loads alongside the MDF .ldfTransaction log, not needed to view the data
03Is the MDF viewer really free?
Yes. Opening, browsing and searching MDF files is free with no time limit, file limit or signup. The paid product is MDF Viewer Pro, which you only need when you want to export the data out of the file into a working database, scripts or CSV.
04Can it open corrupt MDF files?
Yes. The viewer reads the file page by page rather than attaching it, so corrupt, SUSPECT marked and orphaned files open and show everything that survives in readable regions. For files damaged beyond any software, the expert database repair service analyses the file free.
05Can I see deleted records in the file?
Yes, when the deleted rows have not been overwritten by new data. Tick Include deleted records and removed rows appear in the preview alongside live data, with a filter to show deleted items on their own. Viewing them is free. Restoring them to a working database requires MDF Viewer Pro.
06Which SQL Server versions does it support?
All versions from SQL Server 2000 through SQL Server 2025, including Express editions. The viewer reads the version from the file header automatically, so you never need to know which version created the file.
07Can I open an MDF file with SQL Server instead?
Yes. It is worth knowing both routes. Microsoft’s way is to install SQL Server Express with SSMS and attach the file, which turns it back into a live database you can query. That route makes sense when you need to run SQL against the data and the file is healthy. The viewer route wins when you just need to look: no installation weight, no attach step and it opens corrupt and orphaned files that refuse to attach at all.
08Can I export or copy data out with the viewer?
No. The free viewer is read only by design. To export tables to a live SQL Server or save them as .sql scripts and CSV, move to MDF Viewer Pro. It reads files the same way as the free version and adds the full export engine.
09Will it change my MDF file?
No. The viewer opens the file in read only mode and never writes to it, so viewing can never make a corrupt file worse. Everything runs locally on your PC and the file never leaves your machine.
10Does it open NDF secondary files too?
Yes. Select the primary .mdf file and associated .ndf secondary data files load alongside it, so databases split across multiple data files display as one complete object tree.

Download the Free MDF Viewer.
Open Your File in Minutes.

See every table, record and deleted row inside your MDF file right now. Completely free, no SQL Server needed and your file never leaves your PC.

Free Download Ask a Question First
Read only, your file is never modified Since 2005 · SQL Server 2000 to 2025 · Windows 11 to 7