HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Is it OK to use SQL Server availability groups on VMware installations?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
vmwaregroupssqlinstallationsavailabilityserveruse

Problem

Can I use SQL Server availability groups on VMware installations or should I use a hardware installation for the Windows Server Cluster?

Solution

Sure, you can use Always On Availability Groups inside VMware virtual machines (or Hyper-V, or Xen, or cloud provider VMs, etc.)

They're actually a great fit for high availability and disaster recovery for virtual machines because each VM has its own copy of the database.

Keep in mind that if you're trying to avoid single points of failure, then don't put all replicas on the same shared storage, along with your backups. As the great philosophers once said, you gotta eep 'em separated.

Context

StackExchange Database Administrators Q#154479, answer score: 7

Revisions (0)

No revisions yet.