Using SQL AlwaysOn Availability Groups and Failover Cluster Instances

SQL AlwaysOn Availability Groups and SQL AlwaysOn Failover Cluster Instances are high availability and disaster recovery solutions that provide an enterprise-level alternative to database mirroring.

SQL AlwaysOn Availability Groups is available for SQL Server 2012 and later, and SQL AlwaysOn Failover Cluster Instances is available for SQL Server 2014 and later.

An AlwaysOn Availability Group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. The availability group supports a set of read-write primary databases and one to four sets of corresponding secondary databases.

An AlwaysOn Availability Instance supports a failover environment for a complete SQL instance, known as a failover cluster instance. When one instance fails, the secondary instance is activated. Refer to the Microsoft SQL documentation for information on how many secondary instances you can create in your environment.

Note: Multiple listeners on different subnets in an AlwaysOn environment are supported. Contact Vocera Technical Support for details on how to configure the VMP Enterprise Manager to use this capability.

To set up an AlwaysOn Availability Group for VMP, contact Vocera technical support to obtain SQL scripts needed to run on each secondary SQL instance.

To set up an AlwaysOn Failover Cluster Instance for VMP, no specific VMP-related configuration is required.