Hi,
if you want to just move the table to a new filegroup, you need to
recreate the clustered index on the table (after all: the clustered
index is the table data) on the new filegroup you want.
CREATE CLUSTERED INDEX CIX:Table
ON dbo.Table(ClusteringKeyFields)
WITH DROP_EXISTING
ON [newFilegroup]
Question: Can we do this with a partitioned table also? (We don't need any Partition for this table)
Regards
Nicole