• State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 9 subscribers
  • Views 4367 views
  • Users 0 members are here
Options
Related

Alarms backup - Days since last full backup

sebastien courtois
over 5 years ago

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.

Parents
  • 0 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'

Reply
  • 0 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'

Children
No Data