Primary and secondary data files
Every
database has one primary data file and an optional number of secondary data files.
The primary data file stores the information that is needed to start a database up and the location of the secondary data files.
The typical
extension for primary data files is
.mdf and
.ndf for secondary data files.