Articles → SQL SERVER → Files In SQL Server

Files In SQL Server

File Types

1. Primary data file: -
   1. This file points to other data files in SQL Server
   2. This file contains the startup information about the database
   3. Every database has only one primary data file
   4. User data can be stored in this file
   5. The file extension of primary data file is ".mdf."
2. Secondary data file: -
   1. This file stores user data
   2. Secondary data files are optional
   3. The file extension of secondary data file is ".ndf"
3. Transactional log files: -
   1. Transactional log files hold log information used to recover database
   2. There must be at least one log file for each database
   3. The file extension of transactional log file is ".ldf"