Know more about transaction logs and its growth
1. They usually will grow tremendously due to uncommitted transactions
2. Running DBCC REINDEX, CREATE INDEX operations with the database in Full Recovery model.
3. Doing bulk insert query, and select into statements.
The following are the proactive measures in order to minimize the unexpected log file growth,
1.If you do not want point in time recovery of your databases then you can change the recovery model to Simple.
2.Set the size of the transaction log files to a large value to avoid the automatic expansion of the transaction log files.
3.Configure the automatic expansion of transaction log in terms of MB instead of %.
4.Backup the transaction log regularly to delete the inactive transactions in your transaction log if you are using full or bulk logged recovery model.
5.You can switch the recovery model to Bulk logged from full recovery model if you perform some bulk inserts, select into, bcp, alter index, create index commands because these operations will be minimally logged in bulk logged recovery model and after those operations are completed you can switch over to full recovery model.