Indexes are not replicated
-
I reconfigured the transactional replication on my database and i found indexes are not replicated to the subscriber in all the tables how to create the indexes on all the tables in subscriber with out effecting the replication
-
This is part of the settings of the published object. You need to specify if indexes and keys get replicated.
You can script out the creation of the indexes, and create the indexes on the subscriber.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
To be more specific you can change the properties of the replicated object,
Open replication in SSMS and select Properties and select Articles and will bring you to this
You can change the highlighted property to TRUE; remember replicating index might increase the latency
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply