SQL Server Error log alarms require access to the msdb database (4233164)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

SQL Server Error log alarms require access to the msdb database
Descripción

An Alarm was fired from from the "DBSS - Collection Status" which indentified an issue with the msdb database. The rule specified that more details could be found in the SQL Server Error Log. No SQL Server Error Log alarm fired to acknowledge this issue.
"Collection Status: DBSS_Database Failed with the exception: Failed to execute query on instance [WLTVSSSQLSC01], user account [investments\sysdba]. Reason : [Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."
Why didn't a SQL Server Error Log alarm fire for the error?
Causa

The SQL Server Error log alarms require access to the msdb database, datafiles, and logfiles.
Resolución

This issue was replicated in a test environment, when read/write access was removed from the msdb datafile and logfile the SQL Server Error Log alarms would not fire. Functionality was restored when read/write access was reestablished.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Producto(s):: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5, 5.7.1, 5.6.11, 5.6.10, 5.6.7, 5.6.5, 5.6.4; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Título