Thom A - Thursday, September 7, 2017 3:42 AM

anjang2k - Thursday, September 7, 2017 3:31 AM

We are using FULL. No we are not doing frequent log backup.Taking backup of Log is manual activity for us.We do it in 3 months interval.
We intend to automate this process.

That's why it's so large. You need to do transactional back up on a much more frequent basis. And by frequent, I don't mean, Monthly or weekly, I'm talking hourly (at a minimum). Not doing a backup for 3 months is far from ideal.

At the moment, your ldf file is storing transactions up to the last point you did a transactional back up. If that was 2 month and 28 days ago, of course it's going to be huge, it's got almost 3 months worth of transaction details stored.

Edit: If you can't do frequent Transactional Backups, I'd suggest switching to the SIMPLE Recovery model, and then creating a backup of the database.