![Previous Topic: Define a SQL Server 2008 Database Audit Specification](574.png)
![Next Topic: Define SQL Server 2008 Database Files](573.png)
Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2008 Property Editors › Define a Database in SQL Server 2008 › Define a Database Filegroup in SQL Server 2008
Define a Database Filegroup in SQL Server 2008
Use the SQL Server Database File Group Editor to define the filegroups that comprise a database in a SQL Server 2008 physical model.
To define a database filegroup in SQL Server 2008
- Click Target - SQL Server, Databases on the Model menu.
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 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.
- 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:
SQL Server 2005 Physical Files
Add a Comment in a Property Editor
Add a UDP in a SQL Server Physical Property Editor
Copyright © 2013 CA.
All rights reserved.
![Previous Topic: Define a SQL Server 2008 Database Audit Specification](574.png) ![Next Topic: Define SQL Server 2008 Database Files](573.png)
|
|