dbachecks icon indicating copy to clipboard operation
dbachecks copied to clipboard

Backup Checks not ignoring Non-Accessible DB's

Open SacSQLDude opened this issue 7 years ago • 3 comments

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.

SacSQLDude avatar Dec 03 '18 20:12 SacSQLDude

HI @SacSQLDude - I can't replicate this - Definitely none readable?

image

SQLDBAWithABeard avatar Jan 28 '19 15:01 SQLDBAWithABeard

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.

kylejdoyle avatar Feb 14 '19 20:02 kylejdoyle

I dont have any currently testable AGs - Anyone got an update on the current status of this?

SQLDBAWithABeard avatar Aug 24 '21 14:08 SQLDBAWithABeard