The <mssql-filegroups> database configuration element

The <mssql-db-ddl> element in file database-config.xml contains, at most, a single occurrence of subelement <mssql-filegroups>. The use of the <mssql-filegroups> element is optional. Use this attributes to map SQL Server filegroups to PolicyCenter logical tablespaces at the global, database level.

The use of these configuration elements applies to newly created objects only. If you map a specific table to a named filegroup, SQL Server implements the change during table creation or table recreation only. Similarly, if you specify a LOB filegroup for a table or all tables, only newly created tables have their LOB columns stored in the named filegroup. The database does not store newly created LOB columns for existing tables in the named filegroup.

Note: The PolicyCenter schema verification process during server startup reports as warnings any database tables or LOB columns that are not located in a configured filegroup. However, some of the warnings are unavoidable due to the nature of the implementation mechanism and are purely informational.

The <mssql-filegroups> element has the following syntax. The following code sample shows required attributes in bold font. 

<database>
  <upgrade>
    <mssql-db-ddl>
      <mssql-filegroups op="string" admin="string" typelist="string" staging="string" 
           index="string" lob="string"/>
    </mssql-db-ddl>
  </upgrade>
</database>

The following list describes the attributes that you can configure on the <mssql-filegroups> element.

op

Required. Name of a SQL Server filegroup.

admin

Required. Name of a SQL Server filegroup.

typelist

Required. Name of a SQL Server filegroup.

staging

Required. Name of a SQL Server filegroup.

index

Required. Name of a SQL Server filegroup.

lob

Name of a SQL Server filegroup.

The <mssql-filegroups> element does not contain additional subelements.

See also