thanks a lot guys!

I agree with all you have said and will keep monitoring the transaction log growth.:-)

My next question is about Checkpoint.

Do I have to explicitly use checkpoint before/after...

thanks guys.

I have disabled the shrik file job and increased frequency of log backups but i am still worried it might still fill up disk space.