Support for Always On Availability Groups
Always On Availability Groups allow you to increase fault tolerance between active and hot-standby databases without involving shared physical disks, which is quite important for virtualization of Microsoft SQL Servers. Veeam Backup & Replication supports Always On Availability Groups for virtualized Microsoft SQL Server 2012 or later.
Veeam Backup & Replication supports the following Always On Availability Groups:
- Always On Availability Groups based on Windows Server Failover Cluster.
- Always On Clusterless Availability Groups.
Veeam Backup & Replication does not support Always On Availability Groups based on SQL Server Failover Cluster Instances.
Image-level Backup of Microsoft SQL Server VMs
During an image-level backup of a Microsoft SQL Server VM, Veeam Backup & Replication requests and analyzes information about databases that are included in the Always On Availability Groups. Depending on the retrieved information, Veeam Backup & Replication creates a VSS snapshot with or without COPY_ONLY flag. The VSS_BS_COPY flag for VSS snapshot is triggered if the VM represents a secondary node for at least one Always On Availability Group.
Veeam Backup & Replication also detects to what cluster the database belongs. If the backup job does not include all VMs from the cluster, an information message will be issued.
Retrieved information is saved for further log identification.
Transaction Log Backup
Transaction log backup can be performed only for those databases that were successfully backed up, either on the primary or on the secondary node of Always On Availability Group.
The transaction logs processing interval may be the same or may differ through VMs included in Always On Availability Group. If the interval is different, Veeam Backup & Replication will use minimal value (by default, 15 minutes).
At each log processing interval, Veeam Backup & Replication chooses the Always On Availability Group node for which transaction logs will be backed up.
Logs are backed up from one node of the Always On Availability Group. To become a subject for a log backup, the node must meet the following criteria:
- The necessary Veeam Backup & Replication components must be installed on this node and the VM included in Always On 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 Always On Availability Groups for this node were successfully backed up for the last two processing intervals.
- Veeam Backup & Replication can establish a network connection to the node or PowerShell Direct connection, if a connection over the network cannot be established. PowerShell Direct is used for VMs that reside on Microsoft Hyper-V Server 2016 (or later) and run Microsoft Windows 10 (or later) or Microsoft Windows Server 2016 (or later). Veeam Backup & Replication requires Microsoft PowerShell 2.0 (or later) to work over PowerShell Direct.
When you configure a backup job to process Distributed Availability Groups transaction logs, select either primary or secondary distributed availability group. Otherwise, the log chain of the distributed group databases may become inconsistent.
When you configure a backup job to back up transaction logs for other Distributed Availability Groups, use the Perform copy only mode. See Application-Aware Processing to learn more about the copy only mode. You can also use the exclude feature to prevent Guest-OS database from being processed. See Exclude Objects from Backup Job to learn more on excluding objects. To read about distributed availability group limitations, see Configure distributed availability group.