SQL Server 2005 database log size increasing drastically? My friend works in a company (pretty small in size) that is running SagePro ERP which has a SQL server 2005 database. Now the problem is, the database size (over the period of 7 years) has increased to 9 GB which is nothing really but the log file of the database is increasing drastically day by day and has now reached 124 GB.

He is worried that eventually their server might run out of storage if the log size keeps increasing. Upon googling, I found the "shrinkfile" method.  

The question is why is the log file keeps increasing? How do I stop it? is "ShrinkFile" method the best method (I believe its not a permanent solution)?

P.S. They daily take full back-up of database.
Probably either have a long running transaction running (Index maintenance? Big batch delete or update?) or you are in the "default"  recovery mode of Full and have not taken a log backup (or aren't taking them frequently enough). 

refer this link, hope it will help you