Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

NoteNote

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.