PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Federated backups of Always On availability groups

You can use the SQL Server's Always On availability groups feature to place databases in an Availability Group for high availability.

The database administrator can set backup preferences for the availability group and nominate a particular copy, which can be either the primary copy or one of the secondary copies, to use for the backup.

The Microsoft application agent supports federated backups for Application Direct backups. During federated backups, the Microsoft application agent detects the SQL Server's backup preferences setting for the availability group, and then performs the backup on the preferred node.

NOTE On a secondary node, SQL Server supports only copy-only backups of databases. If the preferred node is a secondary node, the Microsoft application agent performs a copy-only backup of databases. SQL Server does not support differential backups on secondary SQL Server replicas. However, you can perform transaction log backups from either copies.

The following figure illustrates an overview of the process interactions during federated backups. In the figure, the backup starts on Node A, but Node B is preferred.

Figure 1. Federated backup command and data flow
Federated backup command and data flow
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\