Microsoft SQL Server Database Events Reference

The Database Agent sends the database events to the Controller when the agent detects that the listener IP is offline and the availability group replica is disconnected or does not synchronize.

You can view the details of the events on the Databases > Events page. This page displays the event summary, triggered time, and database type.

You can view the following information in the details view:

  • Summary: Brief information about the event
  • Details: Properties of the event.
  • Actions Executed: Executed actions if you have created a policy.
Note: If you do not want the Database Agent to send database events to the Controller, then set the dbagent.event.trigger.enabled property to false at the agent level. This property is enabled by default.

The following database events are supported:

DatabaseEvents
Microsoft SQL Server
  • DAYS_SINCE_FULL_BACKUP
  • DAYS_NO_FULL_BACKUP
  • HOURS_LOG_BACKUP
  • BACKUP
Microsoft SQL Server (Cluster)
  • AG_LISTENER_IP_NOT_ONLINE
  • AG_REPLICA_DISCONNECTED
  • AG_REPLICA_NOT_SYNCHRONIZING
  • DAYS_SINCE_FULL_BACKUP
  • DAYS_NO_FULL_BACKUP
  • HOURS_LOG_BACKUP
  • BACKUP
Azure SQL Managed Instance Cluster
  • AG_LISTENER_IP_NOT_ONLINE
  • AG_REPLICA_DISCONNECTED
  • AG_REPLICA_NOT_SYNCHRONIZING
  • DAYS_SINCE_FULL_BACKUP
  • DAYS_NO_FULL_BACKUP
  • HOURS_LOG_BACKUP
  • BACKUP
Azure SQL
  • AG_REPLICA_DISCONNECTED
  • AG_REPLICA_NOT_SYNCHRONIZING