Think I remember seeing a fix in the latest version, haven’t had time to upgrade and text yet though.
From: “Jonathan.Baynes” bounce-JonathanBaynes@toadworld.com
Sent: 22 Nov 2017 10:55
Subject: [Spotlight on SQL Server - Discussion Forum] AlwayOn AG Backups - Supress Backup Alarm for primary Node (when using Backup preferences Secondary only)
AlwayOn AG Backups - Supress Backup Alarm for primary Node (when using Backup preferences Secondary only)
Thread created by Jonathan.Baynes
Can anyone tell me if Spotlight on SQL Enterprise, Backup Alarm Settings can be configured in a way that won’t fire if the Node being monitored is the primary Node.
I want to run all backups on the Secondary only for AG.
What I need is to have the alerts turned on for each node, and on the primary, the backup job is suppressed as its the primary but in a situation where we failover, the alarm would become active for what was the primary and is now the secondary(and vice versa).
Is that feasible?
thank in advance
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Spotlight on SQL Server Forum notifications altogether.
Spotlight on SQL Server - Discussion Forum
this post as spam/abuse.