HYPER V REPLICASE WITH SQL SERVER

skak 21 Reputation points
2020-08-04T13:44:30.643+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,765 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 85,666 Reputation points
    2020-08-04T14:44:48.22+00:00

    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

    0 comments
  2. Cris Zhan-MSFT 6,606 Reputation points
    2020-08-05T09:03:30.61+00:00

    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

    0 comments