AlwaysOn differential database backup alert


Job details

Name: AlwaysOn differential database backup alert
Platform: Sqlserver
Category: Cluster and Replication
Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members.
Long description:
Version: 3.3
Default schedule: 15 6 * *
Requires engine install: No
Compatibility tag: instance[databasetype=‘sqlserver’]/.[alwayson_active=‘YES’]/.[maj_version > ‘2008′ & engine_edition = ‘Microsoft SQL Server’ & eng_inst_priv = 0]

Parameters

Name Default value Description
backup_alarm_threshold 48 Alarm threshold (in hours).
backup_warning_threshold 24 Warning threshold (in hours).
missing_backup_status 1 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when missing differential backup of a database. Only in use if parameter ignore_if_not_implemented is set to NO.
exclude_groups The list of AlwaysON Groups to be ignored (separated by comma).
exclude_databases master, msdb, model The list of databases to be ignored (separated by comma).
check_all_databases YES Includes databases not in AlwaysOn Groups (YES/NO).
ignore_if_not_implemented YES Ignores databases where differential backup is not implemented (parameter value YES).
use_uppercase NO Change all database names to uppercase when checking backup statistics. Should not be used for instances that are case sensitive.

Job Summary

Implementation Details

Configuration

Alerting Logic

Database Coverage

Output and Reporting

Tables Presented in Reports

Title Description
AlwaysOn Groups Shows AlwaysOn group details that have differential backup statistics.
Alarm and Warning Information Lists databases that have backup-related warnings or alarms, indicating potential risks.
Differential Backup Information (AlwaysOn databases) Displays the most recent backup information for databases in AlwaysOn groups.
Differential Backup Information (Local databases) Lists details about the most recent backups for local databases not in AlwaysOn groups.