Meaning of "MSSQL" MDF, NDF, LDF file

meaning of "MSSQL" MDF, NDF, LDF file

2012-09-03 15:32:56| Category: SQL database | Report | Font size Subscription

MDF is the abbreviation of primary data file;
NDF is the abbreviation of secondary data files;
LDF is the abbreviation for log data files.
Not the first letter of the word.

There are three types of files in a SQL Server 2000 database:

Main
The primary data file contains the startup information for the database and points to other files in the database. User data and objects can be stored in this file, or they can be stored in a secondary data file. Each database has a primary data file. The recommended file name extension for primary data files is. mdf.

Secondary
Secondary data files are optional and user data is defined and stored by users. By placing each file on a different disk drive, the secondary file can be used to spread the data across multiple disks. Also, if the database exceeds the maximum size of a single Windows file, you can use a secondary data file so that the database can continue to grow. The recommended file name extension for secondary data files is. ndf.

Transaction log
The transaction log file holds the log information used to recover the database. Each database must have at least one log file. The recommended file name extension for the transaction log is. ldf. MDF is the abbreviation of primary data file;
NDF is the abbreviation of secondary data files;
LDF is the abbreviation for log data files.
Not the first letter of the word. There are three types of files in a SQL Server 2000 database: The primary primary data file contains the startup information for the database and points to other files in the database. User data and objects can be stored in this file, or they can be stored in a secondary data file. Each database has a primary data file. The recommended file name extension for primary data files is. mdf.

Secondary data files are optional and user data is defined and stored by users. By placing each file on a different disk drive, the secondary file can be used to spread the data across multiple disks. Also, if the database exceeds the maximum size of a single Windows file, you can use a secondary data file so that the database can continue to grow. The recommended file name extension for secondary data files is. ndf.

Transaction log
The transaction log file holds the log information used to recover the database. Each database must have at least one log file. The recommended file name extension for the transaction log is. ldf.