File Type Generic IconSQL Server Secondary Database File
File Format Proprietary (Microsoft)
Usage Open manually; may be referenced by an application
Rank ★ ★ ☆  Average

Secondary database file used by Microsoft SQL Server; created when the primary .MDF database becomes too large (such as when there is no disk space left); may also be manually added to the SQL Server File Group to distribute data between the two files.

NDF files are typically stored on a different hard disk or partition than the primary database file. Each NDF file uses the same filename as the corresponding MDF file, such as "mydb.mdf" and "mydb.ndf."

Open With

IconMicrosoft SQL Server

Updated December 31, 2013