Hi everyone,
I have configured Zabbix to monitor Microsoft SQL Server databases using ODBC, and the monitoring is working as expected.
However, I am facing a false alert issue with the "DB Backup Age > 10 Days" trigger for mirrored databases.
Here's the scenario:
Database mirroring is configured between Server A and Server B.
During maintenance or an unexpected failover, the database role switches from Server A to Server B.
The new primary server (Server B) may have an old local backup history (for example, 100, 500, or even 1,000 days old).
The most recent valid backup (less than 10 days old) still exists on Server A, where the backup was actually performed.
Since Zabbix only checks the backup history on the current primary server, it generates a false "DB Backup Age > 10 Days" alert after the failover.
I am looking for a solution that does not require any changes on the SQL Server side. I would prefer to solve this within Zabbix if possible.
Does anyone have any ideas or suggestions for checking the backup age on both servers before triggering an alert? Alternatively, is there a way to suppress or delay the alert for 12 or 24 hours after a failover?
I have configured Zabbix to monitor Microsoft SQL Server databases using ODBC, and the monitoring is working as expected.
However, I am facing a false alert issue with the "DB Backup Age > 10 Days" trigger for mirrored databases.
Here's the scenario:
Database mirroring is configured between Server A and Server B.
During maintenance or an unexpected failover, the database role switches from Server A to Server B.
The new primary server (Server B) may have an old local backup history (for example, 100, 500, or even 1,000 days old).
The most recent valid backup (less than 10 days old) still exists on Server A, where the backup was actually performed.
Since Zabbix only checks the backup history on the current primary server, it generates a false "DB Backup Age > 10 Days" alert after the failover.
I am looking for a solution that does not require any changes on the SQL Server side. I would prefer to solve this within Zabbix if possible.
Does anyone have any ideas or suggestions for checking the backup age on both servers before triggering an alert? Alternatively, is there a way to suppress or delay the alert for 12 or 24 hours after a failover?