合并复制不收敛
所有服务器上的操作系统：Windows Server 2008 R2。
发布者：Sql Server 2008 R2 标准
分发者：SQL Server 2008 R2 标准
Web 同步代理：IIS 7.5 下的 sqlce35.dll
订阅者：Windows XP SP 3 或 Windows 7 SP1 SQL CE Client 3.1
我遇到一个问题，合并复制停止更新订阅而不知道原因。
前提：
- 1 出版物
- 15 项按主机名（）过滤。全部设置为下载，双向模式下无。
- 20 或 30 个订阅者
您创建包含按主机名 () 过滤的多篇文章（15 个表）的合并复制。该副本推送超过 20 或 30 个订阅者，并且同步已正确完成。数据收集是根据订阅者的请求完成的，每天提取更改两到三次。并且订阅者可以毫无问题地收到所有更改。
所有这一切都工作正常，直到有一天，在没有问题的几天后，副本将不再向订阅者更新一些更改。我们搜索发布者并有更改，检查订阅者但没有。返回修改发布者中的更改，有时如果它们在订阅者中更新，有时则没有。
问题是这个副本不再可靠，我们不知道它是否已更新等等。
重点关注单个订阅-EVDBASD342232'013243...'和单个文章'table1'没有获取新数据做了如下验证步骤
运行“sp_showpendingchanges NULL, NULL, 'table1', 1”表示 过程返回一系列与数据相对应的行 应该被复制，我发现 ID 与 subscription-EVDBASD342232 '013243 ...' 且 guid 对应于 'table1' 上应复制的行。
我们请求订阅，并在复制监视器中观察到 查看订阅-EVDBASD342232 '013243 ... '表示 0 次更改并且 一切都是正确的，没有显示任何错误，但不会说什么 待同步。
在分析了所有数据后，我们不明白这个过程中出了什么问题。 一旦一个副本不同步，其他副本也不会同步。
如果有人可以帮忙，请提前致谢。 如果您需要更多说明或详细信息
Operating system on all servers: Windows Server 2008 R2.
Publisher: Sql Server 2008 R2 Standard
Distributor: SQL Server 2008 R2 Standard
Web Synchronization Agent: sqlce35.dll under IIS 7.5
Subscriber: Windows XP SP 3 or Windows 7 SP1
SQL CE Client 3.1
I have an issue where a merge replication stops updating subscriptions without knowing why.
Premises:
- 1 Publication
- 15 items filtered by hostname(). All set to download, None in bidirectional mode.
- 20 or 30 subscribers
You create a merge replication with several articles (15 tables) filtered by a HostName (). This replica push over 20 or 30 subscribers and the synchronization is done correctly. Data collection is done by request from the subscriber, it pull changes two or three times a day. And all the changes are received by the subscriber without any problem.
All this works fine until there comes a time, after a few days without problems the replica will no longer updating a few changes to the subscriber. We search on publicator and have the changes, check the subscriber and not have them. Returning to modify the changes in publicator, sometimes if they are updated in the subscriber and sometimes not.
The problem is that this replica is no longer reliable, we do not know that it is updated and what not.
Focusing on a single subscription-EVDBASD342232 '013243 ... 'and a single article' table1 'is not getting new data made the following verification steps
Run "sp_showpendingchanges NULL, NULL, 'table1', 1" means the
procedure returns me a series of rows that correspond to the data
that should be replicated, I have found that the ID matches the
subscription-EVDBASD342232 '013243 ... 'and the guid corresponds to
the row on the 'table1' that should be replicated.We request subscription and we observe in the Replication Monitor to
view subscription-EVDBASD342232 '013243 ... 'indicating 0 changes and
everything is correct, shows no errors but will not say anything
pending synchronization.
After analyzing all the data we do not understand is what is going wrong in the process.
Once a replica does not synchronize, the others do not either.
Please if anyone can help, thanks in advance.
If you need more clarification or details
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
SQL CE 存在已知的复制问题。
大多数建议是不要使用 CE。
尝试联系希拉里·科特 - 我认为他有一个博客和一个推特。
Twitter #SQLHELP 是尽快获得答案的好地方。大多数 SQL 专家都会为您提供帮助。
SQL CE has known issues with replication.
Most advice is to not use CE.
Try contacting Hilary Cotter - I think he has a blog and a twitter.
Twitter #SQLHELP is a great place to get an answer as soon as possible. Most of the SQL gurus are there to help you.