This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Does Foglight check replica availability?

We are implementing the SQL Cartridge and we are getting errors for the following things:

Databases not being backed up for X days on secondary databases (availability groups, mirrors, etc.)  

SSISDB in an availability group fails the various checks since it is not available on the secondary replica.

 

Is there a setting or configuration to check for primary or secondary database? 

Parents
  • This appears to work if the backup preference of the AG is set to Primary. If it is set to "prefer secondary" (default setting), the preferred replica value is set to 1 on the secondary and so the check runs against the secondary. The primary is the one getting backed since the secondary is not available so the check fails and it reports that the databases have not been backed up.
Reply
  • This appears to work if the backup preference of the AG is set to Primary. If it is set to "prefer secondary" (default setting), the preferred replica value is set to 1 on the secondary and so the check runs against the secondary. The primary is the one getting backed since the secondary is not available so the check fails and it reports that the databases have not been backed up.
Children
No Data