How to Replicate Indexes in Transactional Replication.

• azhar.iqbal499

  SSCrazy

  Points: 2812

  More actions

  August 22, 2011 at 2:13 am

  #242499

  I have implemented Transactional replication. Currently, I run index scripts at both publisher and subscriber manually. I want to replicate the indexes as well. I goggled the issue and find that that indexes are are not replicated by default.

  My Question is that, Is is possible to replicate indexes or not? In case possible then what is the procedure to do it.

  Thanks

  😀

  Azhar

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  August 22, 2011 at 7:56 am

  #1371412

  Yes indexes can be replicated but not by default you need to set the options within the publication article properties.

  MCITP SQL 2005, MCSA SQL 2012