如果在事务复制期间连接丢失会发生什么？
如果在事务复制期间连接丢失会发生什么？
假设 db1 和 db2 正在复制记录，但在复制过程中两个数据库之间的连接丢失。
会发生什么？
what will happen if connection lost during transactional replication?
suppose db1 and db2 are replicating records but during replicating the connection between two databases lost.
what will happen?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
没什么特别不好的。当连接恢复时，分发代理将联系分发数据库并请求命令。不过，您需要了解经销商的最短保留期限；如果您失去连接的时间超过了配置的值，则您可能必须重新初始化订阅服务器，因为继续复制所需的命令可能在分发服务器上不可用。但如果发生这种情况，从错误消息中可以很明显地看出情况。
Nothing particularly bad. When connectivity is restored, the distribution agent will contact the distribution database and ask for commands. You need to be aware of the minimum retention period at the distributor though; if your loss of connectivity goes longer than that configured value, then you may have to reinitialize the subscriber as the commands necessary to continue replication might not be available at the distributor. But if that happens, the situation is pretty obvious from the error message.