Can we make use of log shipping and replication in SQL Server hosted in Hyper V VM
Hi we have an SQL Server running under Hyper V VM and we are planning to make use of log shipping and replication for other availability purposes.But as per Microsoft, they wont support when we enable these HA options in SQL Server running under HyperV. Any of you running your production database servers under Hyper V VM. Thanks,
So yes, if you are using the Hyper-V Replica HA option to replicate the actual VM itself, then no you can't not use those particular features of SQL Server. I read that as Hyper-V Replica pertains to both the primary as well as the replica copy of the VM. This is enabled on the hyper visor not within the VM itself. However, if you are not using that HA feature of Hyper-V, then yes you should be able to use log shipping, mirroring, etc within Hyper-V. Hope that helps. Disclaime: I have little Hyper-V experience so further research will be warranted.