SQL transaction log backup fails after 3 hour timeout
Applies to
- SnapCenter Server (SC)
- SnapCenter Plug-in for Microsoft SQL Server (SCSQL)
- Transaction log backup
Issue
- Transaction log backup for a database(s) fails after 3 hours where SC cannot complete the backup and the unquiesce is delayed
- Error in
<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)
- Fix in KB fails to resolve the issue