SnapCenter SQL日志备份失败、并显示错误:操作系统返回错误21
适用场景
- SnapCenter 4.x
- 适用于SQL的SnapCenter插件
问题描述
SnapCenter SQL 日志备份失败、并显示错误: 操作系统返回错误21
Windows事件查看器显示:Volume L:\<DB> (\Device\HarddiskVolume119) requires an Online Scan. An Online Scan will automatically run as part of the next scheduled maintenance task. Alternatively you may run "CHKDSK /SCAN" locally via the command line, or run "REPAIR-VOLUME <drive:> -SCAN" locally or remotely via PowerShell.
SnapCenter SMSQL日志显示:
ERROR SmSql_567814 PID=[4032] TID=[163] The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000018000 in file 'L:file path'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online