Good morning. Please see this resource on configuring Copy Only backups for SQL AGs:
https://documentation.commvault.com/11.24/essential/128397_configuring_copy_only_backups_on_availability_group_instances.html
A copy only backup can be run on any secondary replica.
Hi @Orazan
I’ve already checked that link…
A copy only backup can be run on any secondary replica.
But how do I specify on which replica I want to run it? (Got an AG here that consists of both physical and virtual nodes… I would like to make sure that the backup runs on one of the physical ones)
/RubeckDK
The preferred replica is a setting within SQL not within Commvault. You set it in the properties of the database.
Hi @Orazan
Thank you for your input…… Much appreciated
I was provided with a test cluster by our SQL geeks, so I could test out on how this works.. It seems that the “"Offload full backup job to secondary replica" setting doesn’t have any effect at all until the SQL admin has configured it within SQL too… In this scenario the primary was still used for the backup UNTIL the SQL admin set the backup preference setting to “Prefer Secondary”. Then the backup started using a replica… Turning off “"Offload full backup job to secondary replica” made the primary to be used again, even though the backup preference setting is set to “Prefer secondary”..
In some previous SP/FR, running a backup directly on a AG node would back up the AG DBs too if not setting the “nBackupAGDBsViaActualInstance” setting to ‘0’….
Anyway, I’ve now figured it out and can move on… :-) Thanks again..
/RubeckDK