Share via

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?

Windows for business | Windows Client for IT Pros | Storage high availability | Virtualization and Hyper-V
Windows for business | Windows Server | User experience | Other
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

Answer accepted by question author

Anonymous
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.

Was this answer helpful?

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.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.