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?

0 Gita Sharifi over 7 years ago

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
0 paul.bankston over 7 years ago

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.
- 0 jonathan nilsson over 7 years ago in reply to paul.bankston
  
  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.
0 Gita Sharifi over 7 years ago

Paul,

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

Gita
- 0 deborah anderson over 7 years ago in reply to Gita Sharifi
  
  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
  - 0 paul.bankston over 7 years ago in reply to deborah anderson
    
    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.
  - 0 Gita Sharifi over 7 years ago in reply to paul.bankston
    
    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
  - 0 Gita Sharifi over 7 years ago in reply to deborah anderson
    
    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.
  - 0 Gita Sharifi over 7 years ago in reply to paul.bankston
    
    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.