Maintenance Plan Reporting - Append To File - Clean Up?

Posted by Adam J.R. Erickson on Server Fault See other posts from Server Fault or by Adam J.R. Erickson
Published on 2010-04-29T18:57:36Z Indexed on 2010/04/29 19:07 UTC
Read the original article Hit count: 399

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, but that creates A LOT of files on the file server. These are hard to sort through, which makes them less useful.

Question: There is an option in "Reporting and Logging" settings for appending all logs together, but how do you clean this out? If you're appending to the same log file every time, how should you make sure this file doesn't grow indefinitely? Is there a build-in function to clean out portions of appended logs like there is for cleaning out individual old log files?

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about maintenance-plan