Skip to main content
4 of 4
deleted 284 characters in body
DoubleVu
  • 305
  • 1
  • 8

Possible Sign That A Database Is Corrupt?

I have a database that's size is 100GB. When I run CHECKDB on it, it fails to due a lack of space for tempdb, which has over 1TB of space. I can restart my SQL Server, flush out tempdb, the drive has 1TB of available space, and run it again, and it will use everything and fail due to a lack of space.

I suspect the database is corrupt because this seems like odd behavior, but is there a scenario where a 100GB database would use more than 1TB for running CHECKDB?

UPDATE

The table that didn't pass DBCC CHECKTABLE, I recreated its indexes and will see if it verifies faster.

DoubleVu
  • 305
  • 1
  • 8