hi,
set some limit to the transaction log file growth. but remember if your transaction log get full then the users will not be able to do anything and will be locked out. So, do backup transactio log on regular basis.
You can select simple recovery model as well but its recommanded not to use it.
Also, truncate log on checkpoint option can be set to automatically remove completed transactions from log file. Its also not recommnaded but can be used with simple recovery model.
best of the best is that you backup log file regularly and also set an alert whcih can backup transaction log if it reaches certain percentage like backup when 75% full. for this a job has to be attached with alert.
bye
miq