2 edited tags
| link
1
source | link

What impact does using backup preference on Availability Groups have?

I am using Availability Groups (database level) SQL Server 2017:

I have set my availability group to "prefer secondary". I have allowed read access on replica. I have created a maintenance plan with full backups on all databases on replica using "copy only" and then also on primary.

But now I'm wondering does AG actually make any decisions? Both Mainenance plans will run and from what I can tell won't change "copy only" to primary's maintenance plan if there's a failover.

Besides just preventing me from running backups if I change the setting..... besides enforcing rules for what [another] dba may or may not be able to do: what is the point of this?

Or, did I setup my backups totally wrong?