maximum number of filegroups in a database? [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that 开发者_开发技巧it can be reopened, visit the help center. Closed 10 years ago.

maximum number of filegroups in a database?

---

For Sql Server 2008

Filegroups per database - 32,767

---

A simple search reveals - 32,767. See the following chart for SQL Server capacity information.

http://msdn.microsoft.com/en-us/library/ms143432.aspx