Transaction log fills up when running query...

[mike1005]

This seems like a simple issue, but yet I don't have a good answer....

I am running a DELETE query against a large database, and, I don't have a whole lot of disk space. My issue is, the log file runs out of disk space before my query can finish.

This is a test DB, so I would perfer not to log this acitivity at all.....but that doesn't seem to be possible. Is there a way to turn off logging, or minimize the entries to get around this???

Thanks.

 

[SQLSister]

Do your delete in Batches.
See this FAQ for how:
How to Use Batch Size to Speed Mass Updates, Inserts and Deletes
faq183-3141