dbachecks icon indicating copy to clipboard operation
dbachecks copied to clipboard

Always On - Backups on Secondary, fail the check on other replicas

Open Ant-Green opened this issue 4 years ago • 0 comments

Bug Report

General Troubleshooting steps

  • [x] Verified running the latest release of dbachecks?

Does (Find-Module dbachecks).Version match (Get-Module dbachecks).Version.ToString()

image

  • [x] Verified errors are not related to permissions?
  • [x] Can duplicate in new/clean PowerShell session (clean = powershell -NoProfile)?

Version Information

  • Operating System (Name|Version): <WS2012R2>
  • PowerShell Version: <PS5.1>
  • SQL Server (Edition|Version): <2014 EE>

Steps to Reproduce

<--
PLEASE include as much information as possible if this is a bug report. The more you include the faster we can identify the problem and get it fixed -->

  • [ ] Attach any screenshots (if possible/allowed)
  • [ ] Attach output from PowerShell console (if possible/allowed)

Description of Bug

<--
I offload my backups to a secondary replica.

This then makes the backups check on the primary or other secondaries report failure as they don't have records in MSDB.

Expected outcome - as part of an AOAG, check all replicas of the group to see which one has the latest backup information and report success for all replicas when a backup is found within the thresholds -->

Ant-Green avatar Jul 28 '21 13:07 Ant-Green