由于暂停超时、SCSQL备份和保留失败
适用场景
- SnapCenter 服务器( SC )
- 适用于 Microsoft SQL Server 的 SnapCenter 插件( SCSQL )
问题描述
- 由于 在备份操作期间、SQL VDI无法在SnapCenter允许的时间范围内(默认为10分钟)使数据库进入静默状态、因此无法应用保留。中的错误
<installation_path>\Program Files\NetApp\SnapCenter\SnapCenter Plug-in for Microsoft SQL Server\log\SmSql_<id>.log
如下所示:
2021-10-24T22:30:31.7418961+03:00 DEBUG SmSql_749 PID=[5364] TID=[84] Executing command - BACKUP DATABASE "<DB_name>" TO VIRTUAL_DEVICE='<Virtual_Device_ID>' WITH SNAPSHOT, DESCRIPTION='NetApp SnapManager Snapshot based backup, restore it using SnapManager.'
2021-10-24T22:30:31.7428970+03:00 DEBUG SmSql_749 PID=[5364] TID=[84] Vdi timeout value - 600000
2021-10-24T22:30:31.7455366+03:00 DEBUG SmSql_749 PID=[5364] TID=[84] Connecting to SQL Server: [SQL_Server_name]
2021-10-24T22:40:31.7356516+03:00 ERROR SmSql_749 PID=[5364] TID=[20] Quiesce could not complete for one or more databases within the timeout.
2021-10-24T22:40:31.7366532+03:00 DEBUG SmSql_749 PID=[5364] TID=[20] Quiesce Done
- 作业日志中未显示任何保留错误