Yes a delete would fill up the logs.

Right now the older data is deleted but going further we would to put in a practice which will delete data which gets older than 2 weeks.

May be put in a cursor and delete one day at a time. Any other way to accomplish this?

Thanks in Advance