Alarms backup - Days since last full backup

Hi,

We have a solution in SQL Server Always-On and we make full backup on primary node. Everything looks good but we always have spotlight Alarm "Backup - Days Since last Full Backup" on secondary. I need the acknowledgement because it's a security if we have a failover. How can I define that the backups are on the primary and thus not generate alarms on the secondary node?

For information we are in version 12.3.1.9810.

Thank you

Sébastien.

0 bf over 4 years ago

I have seen this a few times. Usually this happens when you have failed over to the secondary at some point and the backup runs, and then you fail back to the primary. What i have been doing is run this on the secondary to clean up the backup history on the secondary: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'databasename'
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 jguttman over 4 years ago

I wrote an alarm action to backup the database in question.
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel
0 Gita Sharifi over 4 years ago in reply to jguttman

Also ensure that in Spotlight you've established a SQL Server connection for each replica, along with an AG connection using the listener.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel