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) →
Post your comment on this topic.