What are the three types of Database files? Explain them

What are the three types of Database files? Explain them.

Types of database files:
- Data file: This stores all the data. It has an extension .mdf
- Log file: This stores all the transaction log information. It has an extension .ldf
- Additional data files: Any additional data is stored in these files. It has an extension .ndf

What are the three types of Database files? Explain them.

Database files are used for mapping the database over some operating system files. Data and log information are separate.

SQL server database has three types of database files:
Primary: starting point of a database. It also points to other files in database. Extension: .mdf
Secondary: All data files except primary data file is a part of secondary files. Extension: .ndf
Log files: All log information used to recover database. Extension: .ldf