SQL Server does not enforce the .mdf, .ndf, and .ldf file name extensions, but these extensions help you identify the different kinds of files and their use.In SQL Server, the locations of all the files in a database are recorded in the primary file of the database and in the master database.