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

Question

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?

Answer 1

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.