Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

Use the History Cleanup Task in your maintenance plan.

share|improve this answer
    
I thought that just cleaned out the database table that kept track of the database. I have another task set that can find files by extension (e.g. trn) and delete them from a folder if they're X days old. But can that look inside a file and delete backup data that is X days old? –  Adam J.R. Erickson May 10 '10 at 21:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.