how to solve( Exit code (Decimal ): -2061893606Error description : Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.) this problem installing sql server ?

Question

please help me to solve this problem...

Answer 1

Hi @harihara sudhan,

From the screenshot, it looks like your OS is Win11.

Please attach C:\Program Files\Microsoft SQL Servre\MSSQL15.SQLEXPRESS\MSSQL\LOG\ERRORLOG to locate the issue.

When you try to start SQL Server on a Windows 11 device, the service may fail to start and in the SQL Server error log, you may notice entries similar to:

2021-11-05 23:42:47.14 spid9s 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.MSSQLSERVER\MSSQL\DATA\master.mdf.

SQL Server storage engine logic detects the disk Sector Size and will align the Transaction Log Files metadata and internal boundaries to match the Sector Size (either 512 or 4096 bytes). The error message is generated when SQL Server has detected that Log Entries have been written assuming a Sector Size different to the Sector Size found on the current SQL Server instance.

Please refer to this link:

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size

If this does not solve your problem, you can also provide your summary.txt or detail.txt. These are two important files that can help to view the installation process.

You can find the file path in this link:

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/view-and-read-sql-server-setup-log-files?view=sql-server-ver16

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Deleted.

Answer 3

I am still getting the same error, installed whole new window, repaired everything but still this issue persists