SQL Server Delete – Ran out of disk space

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?

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.

Check more discussion of this question.

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