Are you using replication, mirroring or Availability Groups, then you might also want to run select name, log_reuse_wait_desc from sys.databases.
There might be some additional reasons why your logs grow. Maybe not. Doesn't hurt to check, right.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle