none
Does snapshot replication replaces indexes related to a table article on the subscriber database? RRS feed

  • Question

  • Hi,

    We need specific indexes related to a table article only at the subscriber database. The publisher doesn’t need any indexes.

    Does snapshot replication removes indexes that do not exist on the publisher?

    Thank you,

    Saturday, February 12, 2011 12:02 AM

Answers

  • yes when u creat new snapshot it removes  indexes..but u can run post snapshot script to still maintain indexes or run scripts at subsccxriber after snapshot
    Saturday, February 12, 2011 5:59 AM