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.
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.
Availability Database has not been backed up for too long.
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.
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. | Yes |
Target | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabase | ||
Parent Monitor | System.Health.AvailabilityState | ||
Algorithm | BestOf | ||
Source Monitor | Microsoft.SQLServer.2014.AlwaysOn.Monitor.AvailabilityDatabaseHealth.BackupStatus | ||
Relationship | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth | ||
Category | AvailabilityHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
|
<DependencyMonitor ID="Microsoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityDatabase.BackupStatus" Accessibility="Public" Enabled="true" Target="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabase" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth" MemberMonitor="Microsoft.SQLServer.2014.AlwaysOn.Monitor.AvailabilityDatabaseHealth.BackupStatus">
<Category>AvailabilityHealth</Category>
<AlertSettings AlertMessage="Microsoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityDatabase.BackupStatus.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabase"]/DatabaseName$</AlertParameter1>
<AlertParameter2>$Target/Host/Property[Type="System!System.Entity"]/DisplayName$</AlertParameter2>
<AlertParameter3>$Target/Host/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup"]/UniqueId$</AlertParameter3>
</AlertParameters>
</AlertSettings>
<Algorithm>BestOf</Algorithm>
<MemberUnAvailable>Warning</MemberUnAvailable>
</DependencyMonitor>