We have a SQL Server 2008 cluster with 60 databases.
Full backup runs every night, log backup runs every 15 minutes.
MSDB database recovery model is set to simple (default).
To be able to see the history of these jobs, we had to setup a job cleaning the history log.
But, when this job runs, the log file of
MSDB grows large (20 - 40 GB).
We regularly shrink the log file, as it has "free space" well over 80 %
The log file is set to grow as needed and no "Auto shrink"
Is there any way we can avoid this log file growing?
Should we enable "Auto shrink" or create a job to shrink the log file?