SCSQL备份失败、并显示：数据库"DB_name"的日志不可用
适用场景
- 适用于SQL的SnapCenter 插件
- Microsoft SQL服务器
问题描述
适用于SQL备份的SnapCenter 插件失败、并显示以下错误消息：
2023-02-01T05:30:13.0866220-05:00 ERROR SmSql_259311 PID=[3348] TID=[127] The log for database 'DB_Name' is not available. Check the operating system error log for related error messages. Resolve any errors and restart the database. BACKUP DATABASE is terminating abnormally. 2023-02-01T05:30:13.0866220-05:00 DEBUG SmSql_259311 PID=[3348] TID=[7] SQLBackupRestoreVDI call Done... 2023-02-01T05:30:13.0866220-05:00 DEBUG SmSql_259311 PID=[3348] TID=[7] vdiparam error: The log for database 'DN_Name' is not available. Check the operating system error log for related error messages. Resolve any errors and restart the database. BACKUP DATABASE is terminating abnormally.GetCommand was aborted. 2023-02-01T05:30:13.0866220-05:00 DEBUG SmSql_259311 PID=[3348] TID=[7] Else block- vdiParms check... 2023-02-01T05:30:13.0866220-05:00 ERROR SmSql_259311 PID=[3348] TID=[7] Failed to backup database [DB_Name]. Error: The log for database 'DB_name' is not available. Check the operating system error log for related error messages. Resolve any errors and restart the database. BACKUP DATABASE is terminating abnormally.GetCommand was aborted.SQL host ERORLOG show the following entries:
SQL Server ErrorLog显示以下条目：
2023-01-31 23:02:00.01 spid7s SQLServerLogMgr::LogWriter: Operating system error 50(The request is not supported.) encountered. 2023-01-31 23:02:00.01 spid7s Write error during log flush. 2023-01-31 23:02:00.01 spid24s Error: 9001, Severity: 21, State: 4. 2023-01-31 23:02:00.01 spid24s The log for database 'DB_Name' is not available. Check the operating system error log for related error messages. Resolve any errors and restart the database. 2023-01-31 23:02:00.02 spid24s Error: 5901, Severity: 16, State: 1. 2023-01-31 23:02:00.02 spid24s One or more recovery units belonging to database 'DB_Name' failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log for more detailed information on this failure. 2023-01-31 23:02:00.09 spid60 Error: 9001, Severity: 21, State: 16. 2023-01-31 23:02:00.09 spid60 The log for database 'DB_Name' is not available. Check the operating system error log for related error messages. Resolve any errors and restart the database.