CHECKDB (TEMPDB FULL)

• Super Cat

  SSCertifiable

  Points: 7336

  More actions

  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.

• Grant Fritchey

  SSC Guru

  Points: 398979

  More actions

  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