question

Steinar avatar image
Steinar asked

Replication and indexes

Hi Guys and Girls!

I am setting up a replication solution for a customer, replicating 7 tables, but not all columns in the tables. Publisher and distributor are on SQL 2005 Std, subscriber on SQL 2008 ent.

I have set in the article options for each of the published tables to replicate the clustered index, but not the non clustered ones. All columns involved in the clustered indexes are replicated in all tables.

It works fine on 6 tables, but on the 7:th I get a non clustered index on the subscriber (including the correct columns thou..) instead of the exepected clustered index.

I do not have any errors anywhere, and snapping again does not fix the problem.

Any ideas what might be causing this? And how to fix it?

sql-server-2008sql-server-2005replicationindexing
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
Steinar avatar image
Steinar answered

Hm. Digging deeper into this it tured out that I was a bit fast in my judgement. While dubbelchecking, it turned out that the Index I thought was the Clustered PK on this table was in fact not. In reality the table has a unique index as PK, but but it is not clustered. And I have not choosen to replicate all the columns that was included in the clustered index. So now I just have to maintain a clustered index that will go away everytime we have to reinit the replication. But I guess that serves me right for not checking properly before posting to you guys :-)

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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.