Share via


Creating Filegroups

Filegroups can be created when the database is first created or created later when more files are added to the database. However, you cannot move files to a different filegroup after the files have been added to the database.

A file cannot be a member of more than one filegroup. Tables, indexes, and large object (LOB) data can be associated with a specific filegroup. This means that all their pages are allocated from the files in that filegroup. For more information about the types of filegroups available, see Understanding Files and Filegroups.

A maximum of 32,767 filegroups can be created for each database. Filegroups can contain only data files. Transaction log files cannot be part of a filegroup.

Note

Filegroups cannot be created independently of database files. The filegroup is an administrative mechanism for grouping files within the database.

To add a filegroup when creating a database

To add a filegroup to a database

See Also

Concepts

Creating a Database (Database Engine)

Other Resources

sys.filegroups (Transact-SQL)
Designing Files and Filegroups

Help and Information

Getting SQL Server 2005 Assistance