Question: what are mdf and ndf files in sql server?
Answer: MDF file is a Primary data file (starting point of the database). All the data in the database objects (tables, stored procedures, views, triggers etc.) are stored in the primary data files. NDF file is a secondary data files. ... The rest made up by secondary data files.