Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-01 : 08:44:36
|
| Scott writes "Other than the physical disk space available is there a limit to the number of secondary (.ndf) files i can specify when creating a database?BOL just states...Secondary files hold all of the data that does not fit in the primary data file. Databases need not have any secondary data files if the primary file is large enough to hold all of the data in the database. Other databases may be large enough to need multiple secondary data files, or they may use secondary files on separate disk drives to spread the data across multiple disks.Thanks." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-01 : 08:50:27
|
| There's a really helpful entry in Books Online under "capacity specifications" that lists all of the numerical limits for various features of SQL Server (bytes per rows, objects per database, etc.) The maximum number of files a database can have is 32,767. I believe this would also include however many log files are created for the database. |
 |
|
|
|
|
|
Managing Databases