AlwaysOn Availability Groups
Published 22 November 2018
You can use SQL Backup Pro to back up AlwaysOn Availability Groups, including taking a backup from a ReadOnly secondary replica.
SQL Backup Pro must be installed on each SQL Server instance separately; you cannot use the cluster installation.
You will need to set up the same job on all the replicas, so that in the event of a failover, any scheduled jobs on the failed over replica will continue.
You can use any of the following options to modify the behavior based on the Availability Group configuration:
- use the option CHECK_PREFERRED_AG_REPLICA to ignore backing up on non-preferred replicas. No backup will be taken on non-preferred replicas, however the backup job will succeed.
- use the option SECONDARY_REPLICA_COPY_ONLY to apply the COPY_ONLY flag for full backups on a secondary replica.
- use the options SECONDARY_REPLICA_COPY_ONLY and CHECK_PREFERRED_AG_REPLICA to schedule the same backup job to run on every availability replica. This means that, when using a shared location, it doesn't matter which replica is the primary replica. The database can then be restored without knowing which server was the primary replica.
For additional file name options see File location tags
For more information about the types of backup allowed on Availability Group primary and secondary replicas, see AlwaysOn Availability Groups (SQL Server) and Configure Backup on Availability Replicas (SQL Server) on MSDN.