SQL Server Performance Forum – Threads Archive
Will index on a table get replicated?Hi, Let me straight a way put my question.
I have a table which is set for replication.
I want to add an index to this table which is get replicated.
I would like to know whether this index will get replicated. Also I would like to know whether there are any methods to prevent indexes from being replicated. The purpose is that: I want to keep index on one table but dont want the index to be replicated(if index is also replicated). Please help me with your valuable advices.
Thanks in advance Aji Menachery.
You can manage indexes separately on the publisher and the subscriber databases, once the initial replication has occured. —————————–
Brad M. McGehee, MVP
Thank you very much Brad for the reply! In between we tried including an index in 2 tables which are marked for replication.
We are running merge replication.
Also the subscriber has a Pull Subscription scheduled.
And we found that indexes are not replicated. I must say this!!
www.sql-server-performance.com is ofcourse a wonderful place with immense resources and tips!
I would defenetly recommend this to my colleagues and friends. Once again, thanking you for the reply. Aji Menachery