Skip to main content
  • 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

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Backing up an Always On availability group when there are multiple instance names

When you back up an Always On availability group where the nodes contain SQL Servers with different instance names, the backup command on each instance should reflect the available instance.

For example, consider the following scenario:

  • There are two different instances:
    • SQ12INST4 resides on Node1.
    • SQ12INST5 resides on Node2
  • Node1 is the primary replica.
  • Node2 is the secondary replica.
  • The Always On availability group backup preference is set to secondary.

In this scenario, the backup command on SQL2INST4 should specify the backup object as "MSSQL$SQL2INST4#sql2012-aag3:", while backup command on SQL2INST5 should specify the backup object as "MSSQL$SQL2INST5#sql2012-aag3:". After failover of Node1 and Node2, Node1 becomes secondary, and Node2 becomes primary. The backup command is the same after failover.

NOTE When browsing the backups for a restore operation, the save sets could be in either of the instances (SQL2INST4 or SQL2INST5). The save set depends on the instance that is used for the first backup.

  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: <>()\