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.
Options
- 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.
See Also
Other Resources
ALTER DATABASE (Transact-SQL)
Modifying a Database
sys.databases (Transact-SQL)