I have my WSFC setup with three nodes in my Availability Group. One for DR and one primary and the other active secondary. the secondary will be used to failover should my primary server fail. My question is can I also use the secondary to do backups and reporting on it as well?
If so, if there is an on going backup happening on my secondary node, and suddenly the primary crashes. What happens in this case? Does the backup stop and the failover begins to the secondary node, or does it wait till the backup finishes?
I'm using SQL Server 2016
Reporting off the secondary, read only copy shouldn't be a problem. Just make sure you include ApplicationIntent=ReadOnly in the connection string of of your shared data source.