April 18, 2018 at 9:52 am
I am setting up Transactional Replication between a couple of SQL 2017 Instances. I have discovered that the default setting is to not replicate non-clustered indexes, but we need those to be replicated also. I've used this link to modify the appropriate setting:
https://blogs.msdn.microsoft.com/repltalk/2012/04/03/replicating-non-clustered-indexes-improves-subscriber-query-performance/
However, after I make the change, regen the snapshot and re-synch the subscription nothing changes. In fact, after I make the change and go back and look at the setting, it has been reverted back to False.
Any idea what is going on here?
April 20, 2018 at 1:00 pm
Still trying to get this to work. Rather than trying to change the setting as described above, I'm now trying to recreate the publisher from scratch (using the wizard) and modifying the setting then. What happens in this case is at the end of the wizard I get the following error:
Property or attribute "PublicationName" cannot be modified if "Article" object presents an existing object in the server.
I get this for quite a number of articles (probably all), but the only setting I've changed is to copy nonclustered indexes. This doesn't happen if I don't try to change the setting.
Any thoughts?
April 20, 2018 at 1:25 pm
Del Lee - Friday, April 20, 2018 1:00 PMStill trying to get this to work. Rather than trying to change the setting as described above, I'm now trying to recreate the publisher from scratch (using the wizard) and modifying the setting then. What happens in this case is at the end of the wizard I get the following error:
Property or attribute "PublicationName" cannot be modified if "Article" object presents an existing object in the server.I get this for quite a number of articles (probably all), but the only setting I've changed is to copy nonclustered indexes. This doesn't happen if I don't try to change the setting.
Any thoughts?
Are you changing it by selecting All Articles or doing it individually for each article?
Sue
April 20, 2018 at 1:38 pm
I am changing by selecting all articles.
April 20, 2018 at 2:07 pm
Del Lee - Friday, April 20, 2018 1:38 PMI am changing by selecting all articles.
Try individual article and see if that makes a difference. I had issues with it before when using All Articles. When I was trying to find out what was wrong with that, I did find others having the same issue. I remember one poster saying it wouldn't work until they deleted all tables from the subscriber.
Another option is to just create the indexes on the subscriber manually.
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply