Previous Topic: Define a SQL Server Database Audit SpecificationNext Topic: Define SQL Server Database Files

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

Define a Database Filegroup in SQL Server

Use the SQL Server Database File Group Editor to define the filegroups that comprise a database in a SQL Server 2008, 2012, 2014, or 2016 physical model.

To define a database filegroup in SQL Server

  1. Click Target - SQL Server, Databases on the Model 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 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.

    Contains Filestream

    Specifies whether the filegroup contains filestream data. 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 object.
  7. (Optional) Click the Where Used tab to view where the object is used within the model.
  8. (Optional) Click the UDP tab to work with user-defined properties for the object.
  9. (Optional) Click the Notes tab to view and edit user notes.
  10. (Optional) Click the Extended Notes tab to view or edit user notes.
  11. Click Close.

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

More information:

Add a Comment in a Property Editor

Add a UDP in a SQL Server Physical Property Editor