Create filegroups in SQL Server

Before you begin

Review the information in About filegroups in SQL Server before proceeding with this task.

Procedure

  1. If not already open, open SQL Server Management Studio.
  2. Select the Filegroups page.
  3. Create the following file groups:

    Logical Name

    Usage

    ADMIN

    Stores system parameters.

    OP

    Stores the main PolicyCenter data tables.

    TYPELIST

    Stores system code tables.

    INDEX

    Stores system indexes.

    STAGING

    Stores inbound staging data tables.

    LOB

    Stores off-row LOB (large object) data. The LOB filegroup is optional. If you do not specify a filegroup for the LOB logical tablespace, then PolicyCenter stores the LOB data in the filegroup mapped to the OP logical tablespace.

    PolicyCenter uses the LOB filegroup for new tables only. For an existing configuration in which the PolicyCenter schema already exists:

    • If you designate an LOB filegroup, PolicyCenter does not move existing LOB columns to the LOB filegroup.
    • If you add an LOB column to an existing table, PolicyCenter does not put the column in the LOB filegroup.
    • If you define a new table with LOB data, PolicyCenter stores the LOB data in the designated LOB filegroup.