Out-of-band updates to address Azure Synapse SQL issue caused by Windows updates

Microsoft has identified an issue wherein Azure Synapse SQL Serverless Pool databases enter a “Recovery pending” state, and has expedited a resolution. This issue is observed after installing the June 2024 Windows security update on Windows Server 2022 (KB5039227), Windows Server, version 23H2 (KB5039236), and Azure Stack HCI versions 23H2 and 22H2 (KB5039227). An out-of-band (OOB) update has been released for Windows Server 2022 and Azure Stack HCI, version 22H2 today, June 20, 2024, to address this issue. The resolution for the other platforms affected by this issue will be available in future Windows updates. 

The OOB updates for Windows Server 2022 and Azure Stack HCI, version 22H2 are available on the Microsoft Update Catalog only. These are cumulative updates, so you do not need to apply any previous update before installing them, and they supersede all previous updates for affected versions. Installation of this OOB will require a device restart. If you haven’t deployed the June 2024 Windows security update yet, we recommend you apply this OOB update instead. For more information and instructions on how to install this update on your device, consult the below resources for your version of Windows: