Backup overdue false positive due to log shipping
I am getting some alerts for databases not having been backed up.
The databases in question are secondary log shipping databases so they have no backup information on the secondary for obvious reasons.
Is there any way in SQL Monitor to mark them as Log Shipping secondaries so the alerts do not fire?
I could chose " don't raise alerts" for this specific database but in the event that the roles are switched (think DR) I would want these databases to be monitored for missing backups.
I have also noticed the same behavior for Mirroring secondary's, I'm sure there must be a simple way around this as this isn't an uncommon configuration.