This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Availability Groups and backup alarms

I have read through some of the discussions of how to handle alarms for database backups with Availability Groups but still have not solved my issue.  I do backups from the Primary replica in the Availability Group.  When my AG fails over, I get alarms for my databases that they have not been backed up in so many days.  They have been backed up, only on the other replica.  How do I handle this in Spotlight?

  • Hi Paul,

    Could you let me know the version of your Spotlight from the Help | About window.

    Also, if you can confirm the preferred backup setting of your instance from this screen:

     

    Thanks,

    Gita
    Spotlight Support Team

  • Gita,

    I am using Spotlight 12.2.0.9282.

    Because of the size and number of my databases I need to do differential backups. Since you cannot do differentials on a secondary replica my backup replica is the primary.
  • Paul,

    A private message will be sent to you so our support team can further investigate the issue for you.

    Gita
  • I have this exact issue aswell and their support team have investigated but didn't really find a solution. Hopefully they will implement a solution in the future when enough people complain about this. What I do now is just to snooze the alarms and check the backup jobs with a different solution outside of Spotlight.

  • Gita, this is also a big issue for us since we have many AG clusters.  If there is a work around, we'd be interested in it, too.  We are also on Version: 12.2.0.9282.  Should I open a support ticket? -deb

  • Yes - I am still having this issue. In fact last night one of my AGs failed over and I started getting email after email at 2:00am that my databases had not been backed up.

  • Hi Debrah and Paul,

    Currently, Spotlight Backup alarms are configured to trigger only on the replica that is set as the preferred replica for backup.  I'll check with the product team of possible planned changes and will get back to you.

    Gita

  • Hi Deborah, I wanted to provide an update on the Backup alarm of AG instances. I confirmed with the product team that there are plans to fix the alarm behavior in these instances in the upcoming 12.4 version. You can obtain a status of this change from KB Article 210470. The Spotlight 12.4 Release Notes will also list the fix under the Resolved Issues section. At this point, Spotlight 12.4 is scheduled for towards end of the year.

  • Hi Paul, I confirmed with the product team that there are plans to fix the alarm behavior in these instances in the upcoming 12.4 version. I see that you have an existing support ticket on this issue. Our support team will notify by email once 12.4 is available for download. You can also obtain a status of this change from KB Article 210470. Additionally, the Spotlight 12.4 Release Notes will list the fix under the Resolved Issues section. At this point, Spotlight 12.4 is scheduled for towards end of the year.