Previous Topic: Define SQL Server 2005 Database FilesNext Topic: Define a Database Log File in SQL Server 2005

Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2005 Property Editors › Define a Database in SQL Server 2005 › Define SQL Server 2005 Database Files › Define a Database Filegroup in SQL Server 2005

Define a Database Filegroup in SQL Server 2005

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

To define a database filegroup in SQL Server 2005

  1. Click Target - SQL Server, Databases on the Model menu.

    The SQL Server Database Editor opens.

  2. Select the database in the Navigation Grid for which you need to define a filegroup and click the Files tab.
  3. Click the Filegroups Editor Filegroups Editor Icon in SQL Partition Scheme Editor icon in the Database Filegroups section.

    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 New icon in property editors to create a new object on the toolbar to create a new filegroup. Use the Enter filter text box to filter a very large list of filegroups to quickly locate the one that you want to define.

    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 Where Used tab to view where the filegroup is used in the model.
  8. (Optional) Click the UDP tab to work with user-defined properties for the filegroup.
  9. (Optional) Click the Notes tab to view history information and view or edit user notes.
  10. Click Close.

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

More information:

SQL Server 2005 Physical Files

Add a Comment in a Property Editor

Add a UDP in a SQL Server Physical Property Editor