SQL Server 2019 stopped because of Tempdb issue (During undoing of a logged operation in database 'tempdb' ...............)

Mohamed Said 1 Reputation point
2022-07-13T06:34:35.32+00:00

During undoing of a logged operation in database 'tempdb' (page (0:0) if any), an error occurred at log record ID (1122:26056:565). Typically, the specific failure is logged previously as an error in the operating system error log. Restore the database or file from a backup, or repair the database.

It's not a disk space issue and the tempdb not went full. also, I keep my windows server 2019 with the latest updates and the SQL server too.
This issue almost happens daily months ago, The log didn't help me so much so I went through isolate some tools which interact with the SQL server I started with the backup tool, and the issue keeps happening then finally I stopped the Redgate SQL monitor, after that the issue didn't happen again.
I have created a support ticket for the Redgate team but unfortunately, they deal carelessly.
Does anyone have an explanation for that?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,314 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. YufeiShao-msft 7,046 Reputation points
    2022-07-14T08:42:10.627+00:00

    Hi @Mohamed Said ,

    In general, this occurs if the size of the tempdb log file is not enough to handle tempdb workload, and the auto growth of the log file is set to off, because of limited space,
    But you said it is related to the Redgate SQL monitor, then the reason for the error is not very clear

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

    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.