• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 1 reply
  • Subscribers 59 subscribers
  • Views 278 views
  • Users 0 members are here
Options
Related

DBSS - Unavailable - exception - SQL

agustin garcia
3 months ago

Hi Team

As you well know, this alert in SQL DBSS - Not available. It tells us when a Database is not available, that is, without the status, it is different from Online, but if I want to make an exception so that if the status is in recovery or restoring, it does not alert, where could I do it?

Regards 

AGG

Parents
  • +1 3 months ago

    Hi Agustin,

    The DBSS - Unavailable rule is designed to fire when a database is deemed "unavailable" by the DBSS - Database collection itself and it is written directly into the collection which cannot be modified.

    Knowledgebase article 4251669 describes how the DBSS - Unavailable rule works. 

    There is an enhancement request FOG-4715 was logged to ignore other conditions including offline. I've added a recommendation in add RECOVERY and RESTORING to the request.

    In the meantime, the rule could be customized to use the "status" from DBSS_Database_Properties as a customization of the rule as an alternative. This is detailed in Knowledgebase article 4370110.

    John

Reply
  • +1 3 months ago

    Hi Agustin,

    The DBSS - Unavailable rule is designed to fire when a database is deemed "unavailable" by the DBSS - Database collection itself and it is written directly into the collection which cannot be modified.

    Knowledgebase article 4251669 describes how the DBSS - Unavailable rule works. 

    There is an enhancement request FOG-4715 was logged to ignore other conditions including offline. I've added a recommendation in add RECOVERY and RESTORING to the request.

    In the meantime, the rule could be customized to use the "status" from DBSS_Database_Properties as a customization of the rule as an alternative. This is detailed in Knowledgebase article 4370110.

    John

Children
No Data