我可以停止 SqlServer 复制吗？
我正在运行 12 个 sql server 复制，其中 11 个有 1 个订阅，1 个有 2 个订阅。
现在我遇到了一个非常大的事务日志的问题，我想缩小它，但我收到消息表明事务日志正在使用中。
我怀疑复制（发布，也许订阅）导致了这个问题。
现在，我发现停止发布的唯一方法是删除所有出版物，但这超出了我想要的：暂停发布。
有办法做到这一点吗？
I'm running 12 sql server replications, 11 of which have 1 subscription, and 1 has 2 subscriptions.
Now I have a problem with a very large transaction log which I want to shrink, but I get the messages that the transaction log that is in use.
I suspect that the replication (publication, maybe the subscription too) is causing this problem.
Now the only way I found to stop publication does DROP all thee publications, but that is something more than what I wanted: to pause the publication.
Is there a way to accomplish this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
暂停复制不会达到您想要的效果。当您打开复制时，那些与复制相关的日志记录（即您已配置为复制的对象的日志记录）在到达分发服务器之前不会被标记为可重用。 “暂停”复制的唯一两种方法是停止日志读取器或分发代理，两者都不会将这些日志记录发送给分发器。要查看复制是否是您的问题，请检查数据库的 sys.databases 中的 log_reuse_wait_desc 列并查看其内容。如果是“复制”，那么复制就是你的问题。 :) 如果是，您的日志读取器代理落后多远？
Pausing replication won't accomplish what you want. When you have replication turned on, those log records which are of interest to replication (i.e. those for objects that you have configured to replicate) will not be marked as reusable until they're at the distributor. The only two ways to "pause" replication would be to stop either the log reader or the distribution agent, neither of which gets those log records to the distributor. To see if replication is your problem, check the log_reuse_wait_desc column in sys.databases for your database and see what it says. If it's "replication", then replication is your problem. :) If it is, how far behind is your log reader agent?