FOGLIGHT SQL version 7.3

how to avoid generating alerts that are generated when the databases are different from the online status, i.e. I do not want to be alerted when they are in recovery or any other state?

0 John.Sakalauskas 3 months ago

Hi Agustin,

The DBSS days since last backup rules for SQL Server are coded within the collection not to fire when the database is in RESTORING, OFFLINE, or MIRROR statuses. It uses db_status from the Databases collection to make this determination.

"Normal" would be any condition that is not listed in the bullet points of knowledgebase article 4311845.

Other rules could also then be customized to only fire when the database is "normal".

John
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 agustin garcia 3 months ago in reply to John.Sakalauskas

Thank you for your answer, it gives me light to my issue that I have, is it possible that you share with me the link to the article of knowledge, I can not find it.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Jesus.Nunez 3 months ago in reply to agustin garcia

This is the article mentioned by John earlier: https://support.quest.com/kb/4311845/many-dbss-days-since-last-backup-alarms-are-fired

There is an enhancement request for the DBSS - Unavailable that has not made it into the product yet that I think might be what you're looking for: https://support.quest.com/kb/4295742/scoping-the-dbss-unavailable-rule-to-exclude-databases

You may need a custom rule to implement this functionality.

-J. Nunez
Cancel
Up 0 Down

Reply

Verify Answer

Cancel