Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › Define a SQL Server Database › Define SQL Server Database Filegroups

Define SQL Server Database Filegroups

Use the SQL Server Database File Group Editor to define the filegroups that comprise a database in a SQL Server 2005/2008 physical model.

To define a SQL Server database filegroup

1. Click Databases on the Database menu.

   The SQL Server Database Editor opens.

2. Select the database in the Navigation Grid that contains the filegroup that you want to define and click the Files tab.
3. Click the Filegroups Editor icon.

   The SQL Server Database File Group Editor opens.

4. Select the filegroup in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new filegroup.

   Name

   Displays the filegroup name. You can change the filegroup name in this field.

   Primary

   Specifies whether the filegroup is the primary filegroup. Select the check box to enable this option.

   Is Default

   Specifies whether the filegroup is a default filegroup. Select the check box to enable this option.

   Read Write

   Specifies whether the filegroup is writable. Select the check box to enable this option.

5. Click the General tab and specify the files to include in the filegroup.
6. (Optional) Click the Comment tab and enter any comments that you want to associate with the filegroup.
7. (Optional) Click the UDP tab to work with user-defined properties for the filegroup.
8. Click Close.

   The filegroup is defined and the SQL Server Database File Group Editor closes.

More information:

Add a SQL Server Physical File to a SQL Server Filegroup

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor