Federated restore of availability group database replicas

A computer-implemented method for federated restore of availability group database replicas, the method comprising:

• identifying a primary node in a cluster of nodes in response to receiving a restore request, the primary node storing a primary database replica associated with the availability group, the primary database replica being the only read/write database of the availability group, the restore request being a request to restore all database replicas of the availability group;
• identifying a secondary node in the cluster of nodes, the secondary node storing a secondary read-only database replica based on the primary database replica;
• removing the primary database replica and the secondary database replica from the availability group, the removing preventing data from being written to the primary database replica and the secondary database replica during restoration of the database replicas;
• restoring, as the primary database replica in the primary node, a read/write accessible backup database replica of the same database as the removed primary database replica, and while the primary node is being restored, restoring as the secondary database replica in the secondary node, a read-only accessible backup database replica of the same database, the backup database replica being associated with the availability group;
• and
• adding the restored primary database replica and the restored secondary database replica to the availability group.

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 a primary node in a cluster of nodes in response to receiving a restore request, the primary node storing a primary database replica associated with the availability group, the primary database replica being the only read/write database of the availability group, the restore request being a request to restore all database replicas of the availability group;
• identify a secondary node in the cluster of nodes, the secondary node storing a secondary read-only database replica based on the primary database replica;
• remove the primary database replica and the secondary database replica from the availability group, the removing preventing data from being written to the primary database replica and the secondary database replica during restoration of the database replicas;
• restore, as the primary database replica in the primary node, a read/write accessible backup database replica of the same database as the removed primary database replica, and while the primary node is being restored, restore as the secondary database replica in the secondary node, a read-only accessible backup database replica of the same database, the backup database replica being associated with the availability group;
• and
• add the restored primary database replica and the restored secondary database replica to the availability group.