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.