I have AOAG set up with one of my databases. I only have a primary and secondary replica. For a while now, I've had my backup preferences for the AG set to "Primary" and I've been taking backups successfully using Ola Hallengren's scripts. I'm actually at a point where I have the resources to be able to take (not offload) backups on the secondary too, just as a matter of redundancy. However, when I change my backup preference to "Any Replica" and run Ola's scripts on the secondary, it's not producing a full backup. Is it true that there can be only one instance of SQL Server that can take a backup of an AG at any given point? I was under the impression that backups could be taken from *both* the primary and the secondary when they're both active.
If I can't do this, then I'll just stick with the Primary. If anyone can shed some light, I'd appreciate it.
Thanks in advance,
Mike Scalise, PMP