What is MDF File Extension?

Overview

MDF stands for Master Database File which is a primary database file of Microsoft SQL Server. It saves its files with an extension .mdf. It holds not only the data and schema. It allows users to create multiple data file. It creates a new group of files.

Category

It falls under the database file category.

Supportive Apps

The file extension supports only MS SQL Server.

MIME Type

It has only one MIME type- Application/Octet-stream

Signature

Hex: 01 0F 00 00, ASCII

Location

The location is different for different versions of MS SQL Server-

For SQL 2005

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\

For SQL 2012

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\

For SQL 2014

C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\

The latest 2016

C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\

How to Access MDF File Extension

Users can easily access these files if they are working on SQL server app. There are some paid and free third apps which can help to access these MDF files.