Availability Database Backup Status (Linux rollup)

Microsoft.SQLServer.Linux.Rollup.AvailabilityDatabase.BackupStatus (DependencyMonitor)

This monitor is a dependency (rollup) monitor. The monitor checks availability of a full database backup and its age as reported by Microsoft SQL Server; it does not apply any logic regarding the replicas preferred for the backup.

Knowledge Base article:

Summary

This monitor checks the existence and age of the database backup as reported by Microsoft SQL Server. This is done by running a query against the master database of the SQL instance and returning the age of the database backup. The monitor does not apply any logic regarding the replicas preferred for the backup.

Causes

Availability Database has not been backed up for too long.

Resolutions

You should perform a backup of one of the availability database's replicas to resolve the issue.

To eliminate this issue in future it is recommended to schedule an automated backup according to the needs of the application and business requirements.

Overridable Parameters

Name	Description	Default Value
Alert Priority	Defines Alert Priority.	Normal
Alert Severity	Defines Alert Severity.	Error
Enabled	Enables or disables the workflow.	Yes
Generates Alerts	Defines whether the workflow generates an Alert.	No

Element properties:

Target	Microsoft.SQLServer.Core.AvailabilityDatabase
Parent Monitor	Microsoft.SQLServer.Core.Rollup.AvailabilityDatabase.BackupStatusAggregate
Algorithm	BestOf
Source Monitor	Microsoft.SQLServer.Linux.Monitor.AvailabilityDatabaseHealth.BackupStatus
Relationship	Microsoft.SQLServer.Linux.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth
Category	AvailabilityHealth
Enabled	True
Alert Generate	False
Alert Auto Resolve	False
Remotable	True
Accessibility	Public

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.Linux.Rollup.AvailabilityDatabase.BackupStatus" Accessibility="Public" Enabled="true" Target="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityDatabase" ParentMonitorID="SqlCoreLib!Microsoft.SQLServer.Core.Rollup.AvailabilityDatabase.BackupStatusAggregate" Remotable="true" Priority="Normal" RelationshipType="SqlDiscL!Microsoft.SQLServer.Linux.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth" MemberMonitor="Microsoft.SQLServer.Linux.Monitor.AvailabilityDatabaseHealth.BackupStatus">

  <Category>AvailabilityHealth</Category>

  <Algorithm>BestOf</Algorithm>

  <MemberUnAvailable>Warning</MemberUnAvailable>

</DependencyMonitor>