• English
  • French
  • German
  • Japanese
  • Portuguese
  • Spanish
  • Chinese
  • Italian
  • Table of Content
    Application Category & Support
    How to open MDF File Extension
    Tools to open MDF File
    Join Discussion
    Related File Extensions

    SQL Server Master Database File (MDF/.mdf)

    An MDF (Master Database File) file is the primary database file of Microsoft SQL Server with an extension .mdf, which contains the data as well as schema. We can create more than one data file with .mdf file extension for a database whether it does exist in a filegroup or by generating a new filegroup.

    Database Files.

    • Microsoft SQL Server

    Hex: 01 0F 00 00, ASCII

    The default location of .mdf file depends on its SQL Server version.

    SQL Server 2005

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

    SQL Server 2008

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

    SQL Server 2008 R2

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

    SQL Server 2012

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

    SQL Server 2014

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

    SQL Server 2016

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

    The MDF can be opened using MS SQL server application. There are some free Tools that can be used to view mdf files.

     

    Is this information helpful to you?