AlwaysOn transaction log backup alert


Job details

Name: AlwaysOn transaction log 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: 2.92
Default schedule: 5,35 6-18 * *
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 360 Alarm threshold (in minutes).
backup_warning_threshold 60 Warning threshold (in minutes).
missing_backup_status 2 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when missing transaction log backup of a database.
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 NO Includes databases not only in AlwaysOn Groups (YES/NO).
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

Technical Details

Key Elements

Configuration

Functionality

Alert Generation

Output and Reporting

Tables in Job Output

Execution and Scheduling

Data Privacy and Security