Share via

C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230921_143255

rashed qazizada 0 Reputation points
2023-09-21T12:44:06.8633333+00:00

User's image

SQLServer_ERRORLOG_2023-09-21T14.35.02.txt

SQLServer_ERRORLOG_2023-09-21T14.35.00.txt

SQLServer_ERRORLOG_2023-09-21T14.35.02.txt

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,671 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,296 Reputation points
    2023-09-21T13:26:59.79+00:00

    In the second error log file stands

    There have been 256 misaligned log IOs which required falling back to synchronous IO

    An often seen error in combination of Windows 11 and some SSD, see

    Message misaligned log IOs which required falling back to synchronous IO in SQL Server Error Log

  2. Erland Sommarskog 110.3K Reputation points
    2023-09-21T21:47:24.52+00:00

    As Olaf says, this is a known issue, and Microsoft has published an article with workarounds for the problem.

    0 comments
  3. ZoeHui-MSFT 36,116 Reputation points
    2023-09-22T01:45:36.4066667+00:00

    Hi @rashed qazizada,

    It is a known issue related to system disk sector size greater than 4 KB.

    Check: Troubleshoot errors related to system disk sector size greater than 4 KB

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

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