Always On Availability Groups for SQL Server

You can use Commvault to back up and restore the Always On availability groups disaster recovery solution on SQL Server 2012 and more recent versions.

Always On availability groups support a failover environment for a set of user databases, known as availability databases, that fail over together. An availability group client protects availability databases based on the backup preferences and priorities that are configured for the availability group and provides a single entry point for initiating backups and restores.

Getting Started

The process of getting started with Always On availability groups is the same as for other SQL databases. See Getting Started with SQL Server.

However, Always On availability groups have additional system requirements. See System Requirements for Always On Availability Groups.

Backups

The process of backing up Always On availability groups is the same as for other SQL databases. See SQL Backup Operations.

When you start the backup, the master process retrieves the backup information from the availability group. All activities of the master process are logged in the SQLBackupmaster.log file.

You can run the following backups on the primary and secondary replica:

  • Full and differential backups: These backups always run on the primary replica.

  • Transaction log backups: If the primary replica is set as the preferred replica for running backups, then transaction log backups run on the primary replica. Otherwise, the transaction log backups run on the secondary replica that has the highest backup priority.

Restores

See Restoring an Always On Availability Database.

Loading...