NDF is a secondary database file used along with primary MDF files. If primary file becomes too large or not enough disk space is available (on HDD, SSD, or given partition), a NDF file is automatically created in chosen disk location and the data is distributed between primary and secondary files.

Microsoft SQL Server NDF files are dependent on MDF database files. NDF file can also be manually created by user if the SQL data structure needs to be divided.