question

Sherry avatar image
Sherry asked

How can you get indexes replicated in sql 2005

I have replicated 315 tables. Data comes over, primary keys come over. Other indexes do not come over. Did I miss something? Is my only recourse to script them out and run the script(s) on subscriber? Is there a quick way to script them out.

sql-server-2005replicationindexes
10 |1200

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

mrdenny avatar image
mrdenny answered

When you create the publication you have to specify which articles you want to have the indexes come across for.

Edit your publication. Select Articles. Select the Article Properties button/dropdown. Select the All Tables option. Turn on the clustered and nonclustered indexes. Then rerun the snapshot and push it out to the subscribers.

10 |1200

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

MladenPrajdic avatar image
MladenPrajdic answered

Replication does NOT replicate indexes automatically. Check this thread here. also you have to set copy clustered and non clustered indexes to true.

10 |1200

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.