.NDF File Extension

SQL Server Secondary Database File

Developer: Microsoft

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

Related Formats
3d3d23dm3ds3ds-to-dae3ds-to-dwg3ds-to-fbx3ds-to-glb3ds-to-gltf3ds-to-obj3ds-to-pdf3ds-to-ply3ds-to-stl3ds-to-usdz3mf3mf-to-3ds3mf-to-dae3mf-to-glb3mf-to-html3mf-to-obj

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:

Windows
Open over 400 file formats with File Viewer Plus.Free Download
Microsoft SQL Server 2019

Quick Facts

File Extension
.ndf
Developer
Microsoft
File Type
SQL Server Secondary Database File
Last Updated
2025-11-02T02:43:26.526Z

Related File Types