May 18, 2004 at 1:17 am
Hi all,
Could you help me move the system tables to a new filegroup? Otherwise, I have to move all large user tables to new filegroups.
Stefi
May 18, 2004 at 3:17 am
To place an existing table on a different filegroup (Enterprise Manager)
• Expand Databases, expand the database in which the table belongs, and then click Tables.
• In the Details pane, right-click the table, and then click Design Table.
• Right-click any column, and then click Properties.
• On the Tables tab, in the Table Filegroup list, select the filegroup on which to place the table.
• Optionally, in the Text Filegroup list, select a filegroup on which to place any text, image, and text columns.
Andy.
May 18, 2004 at 3:23 am
That is applicable to user tables. When I try to modify the filegroup of a system table, a message appears that a system table could not be deleted. Probably, this action is completed as a new table is created in the new filegroup, the existing table's data is then moved to it and the old table is deleted.
Stefi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply