Im running transactional replication sql 2008 and have a couple table names with the same name but different schemas. I want to make sure in the replication that the filegroups stay with the subscriber. Is this possible?
Table AAA.Customer on file group A
Table BBB.Customer on file group B
Is there a way to keep these filegroups without rebuilding the index after it has been moved? I noticed there was an option in the replicaiton options to keep file group but it doesn not seem to help. Can you let me know how. THANKS>
View Complete Post