Under normal non-replicated circumstances, we add maintenance plans, scheduled weekly, to rebuild indexs in our SQLServer databases. We have implemented peer to peer replication to run a software project from a major application vendor and the vendor is
stating that "index maintenance plans are unsupported" in this implementation. In order to rebuild indexes, we therefore would need to break replication, rebuild indexes, then re-establish replication.
In short, can index maintenance plans be run against all nodes in a peer-to-peer replication scenario without effecting replication?
View Complete Post