question

pascariadrian avatar image
pascariadrian asked

SQL replication from DB1 to DB2->indexes process

We have DB1 and DB2. We have some extra indexes in DB2. Question: what will happen with indexes from DB2 when data will be replicated from DB1 to DB2?
sqlreplicationindexes
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Cyborg avatar image
Cyborg answered
If you choose Replicate indexes option while defining the articles, the indexes are also applied on each subscriber. But when you add indexes later to the article they are not replicated. > what will happen with indexes from DB2 > when data will be replicated from DB1 > to DB2? When the data replicates, the corresponding indexes are also updated on DB2, it also checks the integrity of data if your indexes defined is unique, replication may fail if they violates data integrity.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.