Database Properties (Filegroups Page)

Use this page to view the filegroups or add a new filegroup to the selected database.

To understand how SQL Server uses filegroups, see Understanding Files and Filegroups and Designing Files and Filegroups.

Name

Enter the name of the filegroup.

Files

Displays the count of files in the filegroup.

Read-only

Select to set the filegroup to a read-only status.

Default

Select to make this filegroup the default filegroup.

Add

Adds a new blank row to the grid listing filegroups for the database.

Remove

Removes the selected filegroup row from the grid.

Community Additions

ADD
Show: