How to place an existing index on a different filegroup (Enterprise Manager)

To place an existing index on a different filegroup

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table containing the index belongs, and then click Tables.
3. In the details pane, right-click the table, and then click Design Table.
4. Right-click any column; then click Properties.
5. In the Selected index list, on the Indexes/Keys tab, select the index to move.
6. In the Index file group list, select a filegroup to place the index on.

See Also

Placing Indexes on Filegroups