<FileGroup> Element (<SubscriptionClass>)
Collapse the table of content
Expand the table of content

<FileGroup> Element (<SubscriptionClass>)

SQL Server 2000

Specifies the SQL Server filegroup on which the subscription table will be created.


Element Characteristics
Characteristic Description
Data Type string, between 1 and 128 characters in length.
Default Value The subscription table is created on the default filegroup specified in the /Database/DefaultFileGroup section of the application definition file (ADF) if the <FileGroup> element is not specified. If the <DefaultFileGroup> element also is not specified, then the default filegroup for the SQL Server instance is used.
Occurrence Optional once per <SubscriptionClass> node
Updates Can be added, deleted, and modified using NSControl Update
Element Relationships
Relationship Elements
Parent Node <SubscriptionClass> Node

The <FileGroup> value must map to one of the <NamedFileGroup> values defined in the <Database> node.

If you update a <FileGroup> element, NSControl Update re-creates the subscription class to which it corresponds. A new subscription table is created, and the existing subscription table is renamed to SubscriptionTableNameOld. Existing subscription table indexes are left unchanged. If you want to transfer data between the old and new subscription tables, it must be done manually.

See Also
Designating the Filegroup
© 2016 Microsoft