Erro ao instalar sql Server 2019 Express. Exit code (Decimal): 2061893606 error description: falha na espera do identificador de recuperação do mecanismo de banco de dados

Question

Ao tentar instalar apresenta esse erro, já tentei as versões 2017, 2019 e 2022 mas a mesma mensagem é apresentada, meu note é Windows 11. Segue anexo log de erro.SQLServer_ERRORLOG_2023-06-26T21.38.15.txt

Answer 1

Hi @Cíntia Queiroz

Please check error logs details and if you find an error message about 256 misaligned reads, this is a known issue and below article suggests workarounds.

Scenario #2 as per the document https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size

Thank you!

Answer 2

Hi @Cíntia Queiroz

Found this in your error log: There have been 256 misaligned log IOs which required falling back to synchronous IO.

This is a known issue when install or start an instance of SQL Server on Windows 11 and Windows Server 2022.

Please troubleshoot follow by this tech doc: Troubleshoot errors related to system disk sector size greater than 4 KB.

Best regards,

Cosmog Hong

---

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

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Olá, não consigo instalar o sql server 2022. Aparece uma mensagem de erro como na imagem. `` Falha na espera do identificador de recuperação do mecanismo de banco de dados. Verifique as causas prováveis no log de erros do sql server. Poderia me ajudar a corrigir o erro?