Backing up availability group databases configured on multi-node virtual servers

1. A system comprising:

a processor-based application, which when executed on a computer having one or more processors, will cause one or more processors to:

identify an availability group scheduled for backup;

determine whether the availability group is operating on a plurality of multi-node virtual servers in a cluster of nodes associated with the availability group;

retrieve information from a multi-node virtual server included in the plurality of multi-node virtual servers in the cluster of nodes in response to a determination that the availability group is operating on the plurality of multi-node virtual servers, the plurality of multi-node virtual servers including a plurality of database replicas of the availability group;

identify, using the retrieved information, a database replica that is preferred for backing up the availability group;

identify a multi-node virtual server in the cluster of nodes that stores the identified database replica;

identify a back-up node, for backing up the availability group, as an active node from a plurality of virtual server nodes in the identified multi-node virtual server; and

back up the availability group via the back-up node by spawning a backup job and sending the spawned backup job to the back-up node.

2. The system of claim 1 , wherein the database replica that is preferred for backing up the availability group comprises one of a primary database replica and a secondary database replica.

3. The system of claim 2 , wherein the primary database replica comprises a plurality of primary database replicas that correspond to a plurality of secondary database replicas comprising the secondary database replica.

4. The system of claim 1 , wherein the retrieved information identifies respective plurality of nodes in at least one of the multi-node virtual servers in the cluster of nodes.

5. The system of claim 1 , wherein the retrieved information comprises a backup preference and a plurality of backup priorities associated with a corresponding plurality of database replicas, wherein identifying the database replica that is preferred for backing up the availability group is based on the backup preference and the plurality of backup priorities.

6. The system of claim 1 , wherein identifying the database replica that is preferred for backing up the availability group comprises one of identifying a primary database replica only, identifying secondary database replicas only, identifying a secondary database replicas preference, and identifying an any database replicas preference.

7. A method comprising:

identifying an availability group scheduled for backup;

determining whether the availability group is operating on a plurality of multi-node virtual servers in a cluster of nodes associated with the availability group;

retrieving information from a multi-node virtual server included in the plurality of multi-node virtual servers in the cluster of nodes in response to a determination that the availability group is operating on the plurality of multi-node virtual servers, the plurality of multi-node virtual servers including a plurality of database replicas of the availability group;

identifying, using the retrieved information, a database replica that is preferred for backing up the availability group;

identifying a multi-node virtual server in the cluster of nodes that stores the identified database replica;

identifying a back-up node, for backing up the availability group, as an active node from a plurality of virtual server nodes in the identified multi-node virtual server; and backing up the availability group via the back-up node by spawning a backup job and sending the spawned backup job to the back-up node.

8. The method of claim 7 , wherein the database replica that is preferred for backing up the availability group comprises one of a primary database replica and a secondary database replica, the primary database replica comprising a plurality of primary database replicas that correspond to a plurality of secondary database replicas comprising the secondary database replica.

9. The method of claim 7 , wherein the retrieved information identifies respective plurality of nodes in at least one of the multi-node virtual servers in the cluster of nodes.

10. The method of claim 7 , wherein the retrieved information comprises a backup preference and a plurality of backup priorities associated with a corresponding plurality of database replicas, wherein identifying the database replica that is preferred for backing up the availability group is based on the backup preference and the plurality of backup priorities.

11. The method of claim 7 , wherein identifying the database replica that is preferred for backing up the availability group comprises one of identifying a primary database replica only, identifying secondary database replicas only, identifying a secondary database replicas preference, and identifying an any database replicas preference.

12. A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein to be executed by one or more processors, the program code including instructions to:

identify an availability group scheduled for backup;

determine whether the availability group operating on a plurality of multi-node virtual servers in a cluster of nodes associated with the availability group;

retrieve information from a multi-node virtual server included in the plurality of multi-node virtual servers in the cluster of nodes in response to a determination that the availability group is operating on the plurality of multi-node virtual servers, the plurality of multi-node virtual servers including a plurality of database replicas of the availability group;

identify, using the retrieved information, a database replica that is preferred for backing up the availability group;

identify a multi-node virtual server in the cluster of nodes that stores the identified database replica;

identify a back-up node, for backing up the availability group, as an active node from a plurality of virtual server nodes in the identified multi-node virtual server; and

back up the availability group via the back-up node by spawning a backup job and sending the spawned backup job to the back-up node.

13. The computer program product of claim 12 , wherein the database replica that is preferred for backing up the availability group comprises one of a primary database replica and a secondary database replica; and

wherein the primary database replica comprises a plurality of primary database replicas that correspond to a plurality of secondary database replicas comprising the secondary database replica.

14. The computer program product of claim 12 , wherein the retrieved information identifies respective plurality of nodes in at least one of the multi-node virtual servers in the cluster of nodes.

15. The computer program product of claim 12 , wherein the retrieved information comprises a backup preference and a plurality of backup priorities associated with a corresponding plurality of database replicas, wherein identifying the database replica that is preferred for backing up the availability group is based on the backup preference and the plurality of backup priorities.

16. The computer program product of claim 12 , wherein identifying the database replica that is preferred for backing up the availability group comprises one of identifying a primary database replica only, identifying secondary database replicas only, identifying a secondary database replicas preference, and identifying an any database replicas preference.

17. The system of claim 1 , wherein determining whether the availability group is operating on a plurality of multi-node virtual servers in a cluster of nodes associated with the availability group comprises:

determining whether the availability group is concurrently supported by at least a first multi-node virtual server and a second multi-node virtual server.