Backup of AlwaysOn Availability Groups
To process AlwaysOn Availability Group, you must complete the following tasks:
- In Veeam Backup & Replication, create a protection group that includes Active Directory objects. Add to this protection group the cluster account of the failover cluster whose data you want to back up.
- In Veeam Backup & Replication, configure a Veeam Agent backup job for a failover cluster. To add a failover cluster to the backup job, do the following:
- At the Job Mode step of the New Agent Backup Job wizard, select Failover cluster.
- At the Computers step of the wizard, add to the job the cluster account that you added to a protection group at the step 1. Alternatively, you can add to the job a container or protection group that includes this cluster account.
- At the Guest Processing step of the wizard, select the Enable application-aware processing option. Then click Applications. In the Processing Settings window, define processing settings. To learn more, see Application-Aware Processing.
To learn more about the backup job configuration, see Creating Agent Backup Job for Windows Computers.
If you select to process transaction logs with the backup job in the Processing Settings window, Veeam Backup & Replication performs the following operations during an image-level backup:
- Requests and analyzes information about databases that are included in the AlwaysOn Availability Groups.
- Depending on the retrieved information, selects the VSS backup type for each computer: full backup (VSS_BT_FULL) or copy-only backup (VSS_BT_COPY). The copy-only backup is created if the computer represents a secondary node for at least one AlwaysOn Availability Group.
To learn more about VSS backup types, see this Microsoft article.
Transaction Log Backup
You can enable transaction log backup in the Processing Settings window. To learn more, see Microsoft SQL Server Transaction Log Settings.
Transaction log backup can be performed only for those databases that were successfully backed up, on the primary or on the secondary node of AlwaysOn Availability Group. At each log processing interval, Veeam Backup & Replication chooses the AlwaysOn Availability Group node for which transaction logs will be backed up. Logs are backed up from one node of the AlwaysOn Availability Group.
To become a subject for a log backup, the node must meet the following criteria:
- The node is not subject to the limitations listed in Failover Cluster Support.
- The necessary Veeam Backup & Replication components must be installed on this node and the computer included in AlwaysOn Availability Group must be running. For more information on the necessary components, see How Microsoft SQL Server Log Backup Works.
- The database backup preferences settings must allow a backup of the node that you want to process. For example, if you want to back up the primary node, you must not exclude this node from a backup, or select the Secondary only option in the database backup preferences settings.
- Databases in the AlwaysOn Availability Groups for this node were successfully backed up for the last two processing intervals.