May 24, 2007 at 4:46 pm
I am using SQL2K5 peer-to-peer replication and I set the copy clustered and non-clustered indexes options to true when I setup replication. Everything seems fine but I cannot seem to get a clear answer as to whether or not running DBCC REINDEX on a replicated table will result in updates to all subscribers. If so, I will modify my reindexing of replicated table so it only occurs on one server. If not, I will reindex all replicated table on each server.
May 24, 2007 at 10:48 pm
Better schedule your DBCC job to run in all servers. By this way you guarantee the same.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 12, 2007 at 12:54 pm
you need to run maintenance on subscribers as well
June 13, 2007 at 7:41 am
Agreed, only data changes are transmitted to subscribers. One of the nice benefits of this is that you can set up different indexes on each subscriber if needed, dont have to worry about keeping indexes in sync with the publisher.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply