SQL Server backup rule fires critical alarms for DR databases (4309922)

The following two SQL Server backup alarms are fired for a DR database that is part of a secondary replica in AG

• DBSS - Days Since Last Backup
• DBSS - Hours Since Last Log Backup

WORKAROUND

Using the Rules Management dashboard, edit the rule and within the Critical condition of both rules, change the these lines

               def preferred_replica_for_backup= dataService.retrieveLatestValue(scope, "preferred_replica_for_backup");

               if(is_always_on.value == 1 && preferred_replica_for_backup.value == 0)

to 

               def preferred_replica_for_backup= dataService.retrieveLatestValue(scope, "preferred_replica_for_backup");

               def backup_not_required = #backup_not_required#;
               if(backup_not_required == 1) return false;
               if(is_always_on.value == 1 && preferred_replica_for_backup.value == 0)

then save the changes to the rule.

STATUS

This issue is fixed as part of defect FOG-1611 in the Foglight 6.1 release of the SQL Server cartridges.