Fix wrong backup check for SQL Always on High availability Groups

[marcohald]

Bug reports

operating system name and version SQL Always on High availability Groups on SQL Server 2019 Windows Server 2019 Detailed steps to reproduce the bug

1. Create a Backup of a High Available Database on Server1
2. Move the Database to Server2
3. You get a backup Error because no actual backup is found

Proposed changes

What is the expected behavior? The Agent should return the Backup status, even if it is not the primary Server What is the observed behavior? The Agent does not return the Backup if it is not the Primary Replica If it's not obvious from the above: In what way does your patch change the current behavior? The Primary Server check is removed Is this a new problem? What made you submit this PR (new firmware, new device, changed device behavior)? The move of the datbase.