question

SKhairuddin avatar image
0 Votes"
SKhairuddin asked ·

HYPER V REPLICASE WITH SQL SERVER

Hello,

We have Windows Server 2016 Standard as Hyper-v host and we would like to deploy SQL Server 2016 in the Guest OS and want to take the advantage of Hyperv Replicas. Has any one deployed this before ??

sql-server-general
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered ·

Hi,

It is possible to use Hyper-V Replica, however SQL's own replication exceeds anything that Hyper-V Replica can do, I believe the recommendation is to use SQL Server's own replication.

You'll find some more information here:
Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment

Best Practices for Virtualizing and Managing SQL Server


(If the reply was helpful please don't forget to accept as answer, thank you)


Best regards,
Leon


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered ·

Hello,

Microsoft SQL Server can be supported on a Hyper-V replica, but the SQL Server high availability features (such as availability groups, database mirroring) are not supported . Please check this article for more details.

Best Regards,
Cris


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.