MDF File

• matt1

  SSCommitted

  Points: 1784

  More actions

  May 30, 2003 at 11:29 am

  #59138

  what is the what, where, why on the MDF File. I want to learn about it.

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  May 30, 2003 at 12:08 pm

  #459249

  MDF is the default extension for a SQL Server database file, much like .doc is for Word and .xls is for Excel.

  Typical file extension standard:

  .mdf - First data file

  .ndf - Additional data file (if needed)

  .ldf - Log file

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley