有没有简单的方法来验证复制文章是否正确？
在出版物（其次是订阅）上，是否有我可以运行的脚本或命令来验证当前的文章是否符合预期和/或正确？
如果手动对复制数据库进行更改（即表的“MSMerge_ins_...”触发器被修改或删除，导致该表的复制无法正常运行），我需要一种简单的方法来检测这一点。
我想避免删除整个出版物并重新添加它。 如果没有其他选择，那就这样吧。
谢谢！
On a Publication (secondarily, a Subscription), is there a script or command I can run that verifies that the articles currently in place match what is expected and/or correct?
If changes were manually made to a replication database (i.e. a table's "MSMerge_ins_..." trigger is modified or deleted, causing replication of that table to function incorrectly), I want an easy way to detect that.
I want to avoid having to delete an entire publication, and re-adding it. If there's no other choice, then so be it.
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
所以您要求检查复制对象，而不是数据本身？ 我不确定是否有官方的方法可以做到这一点。 有一种方法可以验证数据是否匹配...如果您的复制对象出现问题，最终会导致复制期间出现错误或数据发散，因此运行定期复制验证可能有助于实现您的目标。
SQL Server“复制验证”功能使用校验和来验证双方的数据是否正确。 您基本上将订阅“标记”为验证，然后它将在下一次合并后自动验证。
有关该功能的一般讨论，请参阅验证复制数据。 此页面显示如何打开验证。
So you are asking to check the replication objects, rather than the data itself? I'm not sure if there is an official way of doing that. There is a way of validating that the data matches though ... if there was something wrong with your replication objects, it would eventually result in either errors during replication, or divergent data, so running a regular replication validation might help achieve your aim.
The SQL Server 'replication validation' feature uses checksums to verify that the data on both sides is correct. You basically 'mark' a subscription for validation, and then it will automatically validate after the next merge.
See Validating Replicated Data for a general discussion of the feature. This page shows how to turn validation on.