Return
-
Title
Backup alert displaying incorrect info for availability group backups -
Description
'Backups - days since last full backup' alert incorrectly reports the following error on servers servers 'a full backup has not been taken for database xxx in the last xx days on any availability replica' Backups have occurred successfully on one server in the primary location. -
Cause
The Availability Group was not correctly configured.
-
Resolution
Run the command:
SELECT dns_name , port, ip_configuration_string_from_cluster FROM sys.availability_group_listeners
If there is a NULL value in the port column, the Availability Group is incorrectly defined, please use ALTER AVAILABILITY GROUP and fix the issue.