|
in sql 2000 we can attach upto 16 Mdf files using sp_attach_db, from 2005 onwards we use For Attach clause. my question here is, how many MDF files can be created for a particular database.
(comments are locked)
|
|
Microsoft recommend one data file per filegroup per CPU core. http://technet.microsoft.com/en-gb/library/cc966414.aspx In 2005 I'm not aware of any limit on the number of files that can be attached using the FOR ATTACH clause. I have successfully attached more than 20 files of a single database. You're right David, I was looking at the old sp_attach_db. I'm getting old...
Nov 11 '09 at 10:50 AM
Mark Allison
(comments are locked)
|
|
You can create up to 32,767 files in a database. However you can only attach 16 files.
(comments are locked)
|
Your answer
