• State Not Answered
  • Replies 3 replies
  • Subscribers 60 subscribers
  • Views 816 views
  • Users 0 members are here
Options
Related

FOGLIGHT SQL version 7.3

agustin garcia
4 months ago

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?

Parents
  • 0 4 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 

Reply
  • 0 4 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 

Children