.NDF File Extension
SQL Server Secondary Database File
Learn about .NDF files and view a list of programs that open them.
What is a .ndf file?
Learn about .NDF files and view a list of programs that open them.
Properties
More Information
A MDF file has the following data structure.
Page 0: HeaderPage 1: First PFSPage 2: First GAMPage 3: First SGAMPage 4: UnusedPage 5: UnusedPage 6: First DCMPage 7: First BCM
NDF File Header
The page number 0 of all the files contains a header that stores metadata about the file.
Page Free Space (PFS)
PFS identifies the allocation status and determines the amount of free space.
Bit 1: Indicates whether the page is allocated or not.Bit 2: Indicates if the page is from a mixed extent.Bit 3: Indicates that this page is an IAM page.Bit 4: Indicates that this page contains ghost recordsBits 5 to 7: A combined three-bit value, which indicate the page fullness as follows:0: The page is empty1: The page is 1–50% full2: The page is 51–80% full3: The page is 81–95% full4: The page is 96–100% full
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." Also, the NDF file cannot be opened by SQL Server without the MDF file attached.
Technical Details
A MDF file has the following data structure.
Page 0: HeaderPage 1: First PFSPage 2: First GAMPage 3: First SGAMPage 4: UnusedPage 5: UnusedPage 6: First DCMPage 7: First BCM
NDF File Header
The page number 0 of all the files contains a header that stores metadata about the file.
Page Free Space (PFS)
PFS identifies the allocation status and determines the amount of free space.
Bit 1: Indicates whether the page is allocated or not.Bit 2: Indicates if the page is from a mixed extent.Bit 3: Indicates that this page is an IAM page.Bit 4: Indicates that this page contains ghost recordsBits 5 to 7: A combined three-bit value, which indicate the page fullness as follows:0: The page is empty1: The page is 1–50% full2: The page is 51–80% full3: The page is 81–95% full4: The page is 96–100% full
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." Also, the NDF file cannot be opened by SQL Server without the MDF file attached.
How to open .ndf files
To open a .ndf file, you need compatible software that supports this file format.
Programs that open .ndf files:
Quick Facts
- File Extension
- .ndf
- Developer
- Microsoft
- File Type
- SQL Server Secondary Database File
- Last Updated
- 2025-11-02T02:43:26.526Z