NDF file

nav-jkt

Hi all,

Anyone know what is the difference between the .mdf and .ndf file ?
Because when i create a new database in SQL Server Option, it will create two database files, the mdf and ndf file.

Thanks

dsatria

Each SQL database consists of at least two files: one is a primary data file (with the .mdf extension) the other is log file (with the .ldf extension). There are also optional secondary data files (with the .ndf extension).

DenSter

For NAV, you need all three types of files. The database objects are stored in the .MDF file, and the actual data is stored in the .NDF file(s).