Aug 9, 2011
tom

SQL Server Delete – Ran out of disk space

Question

I am deleting 257 million rows out of a table in SQL Server 2008. I can’t truncate it. I probably could have done it smarter though.

2 hours into the delete, the log file grew and I am out of disk space. The query is still running.

What should I do? Will the delete succeed?

Answer

Wait for the tx to roll back, the delete will not succeed. Or load a backup – could be faster.

Either delete in increments (10.000 at a time) or make sure your server is adequate to handle your needs. All that CAN be done there.

Related posts:

  1. Windows Server: Multiple reserved ip’s delete
  2. Does 250 MB SQL Server 2008 R2 space enough?
  3. Disk Space Monitoring
  4. Hard Disk Un-used space
  5. Insufficient disk space; try again later when trying to send mail

Leave a comment