Articles → SQL SERVER → Files In SQL Server

Files In SQL Server

SQL Server stores different objects (tables, indexes, stored procedures, etc.) in files. If you are working in SQL Server, you should know about the various types of files and their purpose.

File Types

There are three types of files in SQL Server: -

Primary data file
Secondary data file
Transactional log files

Primary Data File

The primary data file stores the data in the database. This file contains the startup information about the database. Every database has only one primary data file.

This primary data file contains the startup information about the database. The file extension of the primary data file is ".mdf".

Secondary Data File

The secondary file data is used to store partitioning data across multiple LUNs. Secondary data files are optional. The file extension of the secondary data file is ".ndf".

Transactional Log Files

The transactional log files hold log information used to recover databases. There must be at least one log file for each database. The file extension of the transactional log file is ".ldf"

Posted By -	Karan Gupta

Posted On -	Friday, March 18, 2011

Updated On -	Saturday, September 7, 2024

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**