Backup overdue false positive due to log shipping

MatWaltersMatWalters Posts: 2
edited August 3, 2016 10:34AM in SQL Monitor Previous Versions
Hi

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.

Thanks
Mat

Comments

  • Alex BAlex B Posts: 1,131 Diamond 4
    Hi Mat,

    Unfortunately there is no support within SQL Monitor for mirroring or log shipping specifically, only for Always On Availability Groups. There may be custom metrics (or you could create your own) for these configurations that replicate the normal alert behaviour, but the regular alerts will function as you have seen and you will need to disable them for the problem databases.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.