HI,

I suggest you to investigate the "@allow_partition_realignment" publication parameter.

Yu can set it via sp_addmergepublication / sp_changemergepublication

It allows/prevent data at the subscriber (which are not part of the correct partition).

True : sends deletes to the Subscriber to reflect the results of a partition change by removing data that is no longer part of the Subscriber's partition. false leaves the data from an old partition on the Subscriber, where changes made to this data on the Publisher will not replicate to this Subscriber, but changes made on the Subscriber will replicate to the Publisher.

Setting allow_partition_realignment to false is used to retain data in a subscription from an old partition when the data needs to be accessible for historical purposes.

Bye