We recently moved our 2008 R2 database to a 2016 server. The compatability level was changed to 2016 on the publisher which is also the distributor. The server uses a merge replication to laptop clients using 2016 SQL Express. 30 of 40 clients are working fine. All clients are using pull subscriptions.

The others appear to successfully execute the pull. However, when looking at the details, I can see the Initial snapshot for the merge is being applied everytime the merge subscription is exectued. This is causing our users to lose data that they are entering on the client.

What I expect to happen is, on the first sync, the initial snapshot applied then data that is on the server to be merged. On the subsequent syncs, no snapshot with data being merged in both directions.

Does anyone have any experience with this issue?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.