Skip to main content
NetApp Knowledge Base

SCSQL backups fails with:The log for database "DB_name" is not available

  1. Last updated
  2. Save as PDF
Views:
186
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
SNAPX
Last Updated:

Applies to

  • SnapCenter Plug-In for SQL
  • Microsoft SQL server

Issue

SnapCenter Plug-in for SQL backups fail with the following error message:

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 present the following entries:

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.
 
 

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.