SQL Server Installation Error : Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

After SQL Server 2019 installation on Windows 11 , SQL Server-2019 Service not getting started even I tried manually after installation

TITLE: Microsoft SQL Server 2019 Setup

------------------------------

The following error has occurred:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

When check the Error log found below error

Log location : C:\Program Files\Microsoft SQL Server\MSSQL15.SS2019\MSSQL\Log

log file showing error 2023-05-30 11:44:05.08 spid10s     Starting up database 'master'. 2023-05-30 11:44:05.09 spid10s     There have been 256 misaligned log IOs which required falling back to synchronous IO.  The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER1\MSSQL\DATA\master.mdf.

SOLUTION :

PS C:\Users> Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" Get-ItemProperty : Property ForcedPhysicalSectorSizeInBytes does not exist at path HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device. At line:1 char:1 + Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\storn ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (ForcedPhysicalSectorSizeInBytes:String) [Get-ItemProperty], PSArgumentException + FullyQualifiedErrorId : System.Management.Automation.PSArgumentException,Microsoft.PowerShell.Commands.GetItemPropertyCommand PS C:\Users> New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString -Force -Value "* 4095" ForcedPhysicalSectorSizeInBytes : {* 4095} PSPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device PSParentPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters PSChildName : Device PSDrive : HKLM PSProvider : Microsoft.PowerShell.Core\Registry PS C:\Users> Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" ForcedPhysicalSectorSizeInBytes : {* 4095} PSPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device PSParentPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters PSChildName : Device PSDrive : HKLM PSProvider : Microsoft.PowerShell.Core\Registry

delete the installed SQL Server Instance which was not correctly configured

Reboot the server

Try to Install the SQL Server Instance again

Hope it will work, In my case it is working and successfully installed SQL Server Instance