Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 3 down vote accepted

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.

share|improve this answer

How many records do you need to retain in the table compared to 257 million deletes? If that number is smaller then insert those records in batches to a new table, switch the tables around using ALTER TABLE SWITCH and drop the older table.

Another interesting idea is to setup partitioning and drop the older partitions.

share|improve this answer
This is indeed useful information. Thanks – bladefist Jun 20 '11 at 13:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.