It is inclusive of all files.

I think here 'N' stands for the number (ie) 1 to 32766 (after one file for primary)

-----Original Message-----
From: Yukon DBA [mailto:[Email Address Removed] Wednesday, October 16, 2002 4:24 AM
To: LazyDBA.com Discussion
Subject: Max files per database


There a limitation for physical files per database in SQL Server 2000. ie 32767 files per database. Is it log files included?

1mdf -- one primary file
Nndf -- N secondary files
Nldf -- N log files..... What is N?


Thanks in advance.....
MS Sql Server LazyDBA home page