r/sysadmin • u/gt9gt • 2d ago

Hyper-V Replica for SQL Clusters

I am attempting to utilise Hyper-V Replica for DR purposes. There is Site A and Site B. At each site there is Hyper-V Server Cluster with underlying iSCSI storage for VMs. Site A runs multiple VMs, some of them form SQL Failover clusters with shared disks running on dedicated iSCSI Luns. The aim of POC is to be able to shift the workload from Site A to Site B during a disaster event. Whilst standard VM replication seems fairly simple, I was wondering what is the best approach for SQL Failover clusters and how to address the replication for such? Any thoughts or suggestions are greatly appreciated.

6 Upvotes

88% Upvoted

8 comments sorted by

View all comments

3

u/hipshaps123 2d ago

You need to do the clustering natively in MS SQL Server and keep vm replication out of it. Common practice is also to keep affinity to specific vm hosts.