Maintenance Plan Reporting - Append To File - Clean Up?
- by Adam J.R. Erickson
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…