Skip to Content
Former Member
Jan 22, 2010 at 05:49 PM

Client Deletion, Transaction log getting full.


Hi Gurus,

We are trying to delete a client by running:


client = 200 (*200 being the client we want to remove)

select *

The transaction log disk space allocated is 50GB, it is getting full (in simple mode) and client deletion never completes. The size of the table it is accessing is 86 GB, and i think 200 client will be occupying around 40-45GB. Client 200 has 15.5 million rows in the table.

I am i giving proper command ?is there any explicit commit i can include or any workaround for deleting the client and not hammer the log file.

Thanks guys

Edited by: SAP_SQLDBA on Jan 22, 2010 6:51 PM