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
sql-server-2005
|maintenance-plan
|sql-server
|database-backups
|database-adminstration
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