SCSQLバックアップが次のメッセージで失敗します。The log for database "DB_NAME" is not available
環境
- SnapCenter Plug-in for SQLの略
- Microsoft SQL Serverの略
問題
SnapCenter Plug-in for SQLのバックアップが失敗し、次のエラーメッセージが表示されます。
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.