Rebuilding indexes on a replicated database RRS feed

  • Question

  • Hello there,

    I am planning to rebuild the highly-fragmented indexes on my db which has both transaction and merge replications on many of its tables in addition to a number of indexed views. Fragmentation percent is almost the same on both servers, so my question is: can I rebuild the indexes on both the publisher and subscriber manually without the need to recreate all these replications taking into account that almost all the indexes are on the primary keys of the replicated tables. My first thought was to rebuild the indexes on either server, take a copy of the database and recreate all the replications. This is a long process and will take almost 18 hours.

    Any ideas?

    Thanks in advance

    Ghada M.Ahmad

    Monday, March 31, 2014 9:41 PM

All replies