dbachecks
dbachecks copied to clipboard
Backup Checks not ignoring Non-Accessible DB's
When running the latests Backups checks, we get a lot of errors and warning for DB's that are in a AG or non-accessible. If a DB is not the primary and is not accessible (Non-readable) can it be skipped. In this case, we use the secondary DB's as a warm standby for DR only.
HI @SacSQLDude - I can't replicate this - Definitely none readable?

I am seeing this same issue. If the Availability Group is configured with ALLOW_CONNECTIONS = NO a bunch of the checks fail since it doesn't look like they first check to see if the database is in an Availability Group and/or check if the Availability Group is set to ALLOW_CONNECTIONS = YES.
Once that is out of the way the backup checks also don't take the backup preference into account when checking if there is a recent backup. For example, if you backup preference is set to primary only then you would expect the databases on the secondary replicas to not have a recent backup.
I dont have any currently testable AGs - Anyone got an update on the current status of this?