Home Forums SQL Server 2012 SQL Server 2012 - T-SQL why we need secondary(.ndf) file in Database RE: why we need secondary(.ndf) file in Database
Bhaskar.Shetty
Hall of Fame
Points: 3054
More actions
June 8, 2013 at 5:19 am
#1622220
whenever you create a database with multiple data files, the first file will be created as .mdf and all other as .ndf.
Normally we create database with multiple data files to keep the data on different IO disk, for better performace and management.