This is a scenario I hope won’t happen, but if I was to perform a manual failover on an availability group halfway through a database backup will this cause the backup to fail or would it continue? I’ve been looking through MS documentation but can’t find this specific case.
I’m running SQL 2017 in an active – active environment with the listener in a third location. (synchronous commit)
(Backups are utilizing the Ola Hallengren scripts)