My database transaction log files grow a lot suddenly. I am using simple recovery model.
BACKUP LOG mydb WITH TRUNCATE_ONLY
Code as above does the trick but I have more than 25 databases on server. I wish to have a SQL server agent job doing the cleaning work each night.
Have you come across such script?