Limitation on number of mdf/ndf file for a single DB

• ARUL-285958

  Ten Centuries

  Points: 1081

  More actions

  January 6, 2006 at 3:13 am

  #112129

  Hi team

  Just wanted to know is there any limitation of having primary and secondary files for a single DB. We have a DB worth 1 TB and rite now it has 23 primary file and 10 secondary files in it...

  Plz let me know this for both SQL '2000 | 2005.

  Rgds,

  A

  ---

  Get busy living ....or get busy dying....

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  January 6, 2006 at 10:07 am

  #613310

  A database can have just one primary file.  Each database is limited to 32,767 files including the primary file and log files.

  Greg

  Greg