Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

PDF

Federated backups of Always On availability groups

You can use the Microsoft SQL Server 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 Microsoft SQL Server's backup preferences setting for the availability group, and then performs the backup on the preferred node.

NOTE:On a secondary node, Microsoft 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. Microsoft SQL Server does not support differential backups on secondary Microsoft 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

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  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: <>()\