Supported Microsoft SQL Server high-availability configurations

This article applies to:

 

• Acronis Backup for VMware 9 (Acronis vmProtect 9)

Description

Acronis Backup for VMware 9 (Acronis vmProtect 9) supports the following Microsoft SQL Server high-availability configurations:

• Microsoft SQL Server Database Mirroring

Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.
There are two configuration types of MS SQL Server Database mirroring:

1. Configuration, that includes principal and mirror server;
2. Configuration that includes principal, mirror and witness server.

For more information about MS SQL Server Database mirroring refer to the Microsoft documentation: http://msdn.microsoft.com/en-us/library/ms189852.aspx

Acronis Backup for VMware 9 (Acronis vmProtect 9) supports:

•  Backup and restore of full mirroring configurations and separate principal servers;

  (!) After the restore of a single principal server (without mirror and witness server) you need to reconstruct the original mirroring configuration manually.

• Extract databases from backups of principal servers;

  (!) Backup and extract of databases from backups of mirror servers are not supported for both configurations of mirroring installation: with witness server and without it.

• AlwaysOn Availability Group (AAG)

The AlwaysOn Availability Group is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica, which hosts the primary databases, and one to four secondary replicas, each of which hosts a set of secondary databases and serves as a potential failover targets for the availability group. For more information refer to the Microsoft documentation: http://msdn.microsoft.com/en-us/library/hh510230.aspx

Acronis Backup for VMware 9 (Acronis vmProtect 9) supports:

• Backup and restore of full AAG configurations and separate primary and secondary replicas without losing the AAG configuration;
• Extract databases from backups of primary and secondary replicas;

(!) By backing up the secondary replica of AAG the following values should be defined to allow all connections to secondary databases of this replica:

• Availability Mode: Synchronous commit
• Readable Secondary: Yes

For more information refer to the Microsoft documentation: http://msdn.microsoft.com/en-us/library/hh245285.aspx