Home Forums SQL Server 2008 SQL Server 2008 - General Change filegroups for existing table from Primary to FG_JJ RE: Change filegroups for existing table from Primary to FG_JJ
dbafromthecold@gmail.com
SSChampion
Points: 10160
More actions
January 30, 2013 at 3:27 pm
#1582723
If the table has a clustered index on it you could rebuild the table, moving the clustered index to the new filegroup. That will move your data.
I would not think that replication will break but I would test this first.
Andrew