Post reply

CHECKDB (TEMPDB FULL)

  • November 27, 2024 at 9:05 am

    #4489751

    • It's been donkeys years since this has happened to me, but I cannot remember if when running CHECKDB and it causes TEMPDB to be full. Does that cause a server outage or just the process of CHECKDB to fail.

  • November 27, 2024 at 2:14 pm

    #4489918

    Generally, it'll cause CHECKDB to fail. However, I've seen it where it takes the server offline. This is because the rollback that has to occur, also needs some disk space, funny enough, in tempdb. When there isn't any, the rollback can't occur, but nothing else can roll forward, so SQL Server rolls over.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply