Asked a question
yesterday about creating a backup job to fully backup my system and all the working databases weekly, and do incremental backups daily. Looks like this is going to work well.
So, the next question is:
How do I add a step to the weekly backup to shrink the log files for each of the system and production databases after the full backup is completed?
If the log file inevitably reaches a certain size, pre-allocate it to that size in large allocations and leave it alone.