Delete fills logs.

[ezecastle]

I'm trying to do a very large delete. I set the db to simple mode thinking that the Trans Log will not fill during the delete.

But it does still fill. I thought if you used simple mode the logs are not used?

Any thoughts?

[ezecastle]

Could it be that the table has indexes? If this is the case they should be deleted then recreated after the delete, correct? Or am I off with this thought.

thanks

[rmiao]

Nothing to do with index, you should delete rows in small batch.

[ezecastle]

OK, hmm can I do that with sql statements or do i have to use a batch file?

Thanks for your time.

[rmiao]

You should modify where clause for that.

[ezecastle]

Thanks for your help.