Hyper-V replica - EnableWriteOrderPreservationAcrossDisk for SQL VM not working

Stefanos Papaefthimiou 20 Reputation points
2024-05-28T06:44:01.8033333+00:00

According to Support policy for hardware virtualization product - SQL Server | Microsoft Learn, Hyper-V replica for a VM running SQL server is a supported scenario as long as you enable EnableWriteOrderPreservationAcrossDisks as described in the article.

When I execute the PowerShell command i get the following output "WARNING: 'EnableWriteOrderPreservationAcrossDisks' is not required for 'Set-VMReplication'". The question is although I get this warning message, is it enabled or not? What should I do to be sure that the setting is enabled, is there anything that I could check? Registry maybe?

The SQL VM is running Windows 2022 standard, SQL 2022 server standard with CU13 and has 4 vhdx, OS, SQL data, SQL logs, Tempdb, the Hyper-V host is Windows 2022 standard, May MS updates installed.

Any ideas or experience with that?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,080 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,423 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,597 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ian Xue (Shanghai Wicresoft Co., Ltd.) 32,161 Reputation points Microsoft Vendor
    2024-05-30T01:01:55.0833333+00:00

    Hi Stefanos Papaefthimiou,

    Thank you for posting in Q&A.

    You can check the EnableWriteOrderPreservationAcrossDisks property of the replication settings of a VM by running

    Get-VMReplication -VMName <VMName> | Select-Object VMName,EnableWriteOrderPreservationAcrossDisks
    

    The value of EnableWriteOrderPreservationAcrossDisks will be True if it's enabled.

    Best Regards,

    Ian Xue


    If the Answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Stefanos Papaefthimiou 20 Reputation points
    2024-05-30T05:26:49.64+00:00

    Thank you for your answer Ian,

    The output of the command you suggested indicates that it's enabled:

    VMName EnableWriteOrderPreservationAcrossDisks


    vmname True

    It seems that although I get the warning, it enables the value.

    0 comments No comments