Articles → SQL SERVER → Files In SQL ServerFiles In SQL ServerSQL 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 fileSecondary data fileTransactional log filesPrimary 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
Query/Feedback