Define a Database Filegroup in SQL Server 2012

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

Follow these steps:

Click Model, Target - SQL Server, Databases.
The SQL Server Database Editor opens.
Select the database in the Navigation Grid that contains the filegroup that you want to define and click the Files tab.
Click the Filegroups Editor icon in the Database Filegroups section.
The SQL Server Database File Group Editor opens.
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 filegroup. Use the Enter filter text box to filter a large list of filegroups to locate the one that you want to define.

Name

Displays the filegroup name. For example, SalesEMEA, SalesAPAC, or SalesNA.

Primary

Specifies whether the filegroup is the primary filegroup.

Is Default

Specifies whether the filegroup is a default filegroup.

Read Write

Specifies whether the filegroup is writable.

Contains Filestream

Specifies whether the filegroup contains filestream data.
Click the General tab and specify the files to include in the filegroup.
(Optional) Click the Comment tab and enter any comments that you want to associate with the filegroup.
(Optional) Click the Where Used tab to view where the filegroup is used in the model.
(Optional) Click the UDP tab to work with user-defined properties for the filegroup.
(Optional) Click the Notes tab to view history information and view or edit user notes.
Click Close.
The filegroup is defined and the SQL Server Database File Group Editor closes.

More information: