Changing the Default Filegroup

Creating and Maintaining Databases

Creating and Maintaining Databases

Changing the Default Filegroup

When you change the default filegroup, any objects for which no filegroups have been initially specified are allocated to the data files in the new default filegroup. Changing the default filegroup prevents user objects that are not specifically created on a user-defined filegroup from competing with the system objects and tables for data space.

To change the default filegroup

Transact-SQL

SQL-DMO

See Also

Default Filegroups