Al-Rahim (10/24/2012)
However, the ldf file remains much bigger than i should like
It wil grow as it is nature of LOG file. the operation will get performed more LOG will grow , manage certain tasks like rebuild indexing , T-sql which are handling long heavy intermediate steps MEANS long-running transaction case.
So better to do proper regular log backup OR add more disk for log
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)