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?
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?
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
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.
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
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