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: [CDATA[instance[databasetype=‘sqlserver’]/.[alwayson_active=‘YES’
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.

← Page verify option / Transaction log space usage (2008-2016) →

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment