Primary
Every database will have one primary data files with extension .mdf.That stores the basic information of database and point to other files in the database.
Secondary
It is optional file.That can be used for spreading data on different drive.It has extension .ndf.
Transaction Log
The transaction log files contain log information of database that is used to recover the database. It will have extension .ldf.
That’s It.
Enjoy Learning.
No comments:
Post a Comment