42139: Acronis Backup for VMware 9: Protecting Microsoft SQL Server High-Availability Configurations

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

 

 

Tags: 

You are reporting a typo in the following text:
Simply click the "Send typo report" button to complete the report. You can also include a comment.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
2 + 2 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.