最近发现个问题,sql 2012 在启用了Always on Group 后,事物日志不断增大,无法截断。日志都50G了。通过上网查询
Thanks, everyone, but we already know all that. As it turns out we discovered what the problem was. In our backup preferences it was set to the default setting, which was "Prefer Replica'. I change it to 'Primary'. Then after the tlog backup the logs shrank just fine.
Thanks, all.
在我们的备份选项,改变备份应在何处执行为'主副本'。然后在事务日志收缩就好了。
还有一哥们的解决方案,未测试。
You have to backup log periodically like every 15 minutes.
阅读(2853) | 评论(0) | 转发(0) |