SQL Server: SQL 2008 r2
Is there a way to change the FileGroup for a sql table having 16m records from Primary to (for instance) FG_IT
If 1 is possible then i would need help on what will be the best approach for the following scenario:
It has an Indexed View for a base table that has a File Group IT_JJ. In the past we setup Indexed View replications BUT with with the source table having a file group pointing to Primary.
Using tsql for creating logbased replication there is an option in sp_addarticle @schema_option and use the following option (i have to yet try this option out..never done this)
0x40000 (Replicates filegroups associated with a partitioned table or index.)
This has file group name FG_JJ
If 1. is true and i did change the filegroup on the Destination table, will replication break?
Help would be greatly appreciated.