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:
- Configuration, that includes principal and mirror server;
- 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