September 12, 2013 at 5:11 am
Hello, Good Morining!
I need your knowledge about replication. I have been replicated a database, but I have to add indexes to a table that is published.
I published again the table with the new indexes and reboot the replication, but the new indexes are not in the replication.
When we add indexes, are these indexes replicate?
Viky
November 15, 2013 at 7:49 am
Hi
By default, the nonclustered indexes are not copied. You can enable this though when you setup the publication. It's on the screen where you select the articles to add.
January 8, 2014 at 6:22 pm
Hmm, I thought (and from experience) that non-clustered indexes are copied by default, but only on setting up subscription. Just now looking at the article options it is showing "copy non clustered indexes" as true. I've wasn't aware of an option to synchronise further nonclustered indexes though.
When we have this situation, we just run the index scripts on the subscribers also.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply