SQL事务日志备份在3小时超时后失败

最后更新
另存为PDF

Views:: 3

Visibility:: Public

Votes:: 0

Category:: snapcenter

Specialty:: snapx<a>SQL</a><a>日志备份</a><a>超时</a><a>2009年277631 </a>

Last Updated:

适用场景

SnapCenter 服务器（ SC ）
适用于 Microsoft SQL Server 的 SnapCenter 插件（ SCSQL ）
事务日志备份

问题描述

数据库的事务日志备份会在3小时后失败、在此期间、SC无法完成备份、并且暂停操作会延迟
中出现错误 <installation_path>\Program Files\NetApp\SnapCenter\SnapCenter Plug-in for Microsoft SQL Server\log\SmSql_<id>.log

DEBUG SmSql_5598 PID=[3324] TID=[35] Log backup for database [Database_Name] to the File mountpoint\Database_Name is starting... DEBUG SmSql_5598 PID=[3324] TID=[35] Backup of database [Database_Name] percentage of completion : 10... DEBUG SmSql_5598 PID=[3324] TID=[35] 10 percent processed. DEBUG SmSql_5598 PID=[3324] TID=[35] Backup of database [Database_Name] percentage of completion : 20... DEBUG SmSql_5598 PID=[3324] TID=[35] 20 percent processed. DEBUG SmSql_5598 PID=[3324] TID=[35] Backup of database [Database_Name] percentage of completion : 30... DEBUG SmSql_5598 PID=[3324] TID=[35] 30 percent processed. DEBUG SmSql_5598 PID=[3324] TID=[35] Backup of database [Database_Name] percentage of completion : 40... DEBUG SmSql_5598 PID=[3324] TID=[35] 40 percent processed. DEBUG SmSql_5598 PID=[3324] TID=[35] Backup of database [Database_Name] percentage of completion : 50... DEBUG SmSql_5598 PID=[3324] TID=[35] 50 percent processed. DEBUG SmSql_5598 PID=[3324] TID=[35] Backup of database [Database_Name] percentage of completion : 60... DEBUG SmSql_5598 PID=[3324] TID=[35] 60 percent processed. DEBUG SmSql_5598 PID=[3324] TID=[54] UnQuiesce start ERROR SmSql_5598 PID=[3324] TID=[35] ErrorCode (-1), ErrorMessage (The wait operation timed out)

KB中的修复无法解析问题描述