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.
asked Nov 11, 2009 at 08:50 AM in Default
Microsoft recommend one data file per filegroup per CPU core.
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.
answered Nov 11, 2009 at 10:36 AM