Online Documentation for SQL Administrator for SQL Server
Clean up maintenance log
Use the Clean Up Maintenance Log Task dialog to remove old files related to maintenance plans, including text reports created by maintenance plans and database backup files.
The General tab allows you to set common properties for this task. To set relationships between tasks use the Precedence constraints tab.
Name
Enter the task name.
Enabled
Check this option to enable task execution.
Connection
Specify which server connection should be used for task execution. You can choose among existing connections or create a new one.
File types to remove
Backup files
Delete SQL Server backup files.
Maintenance plan reports
Delete text reports of previously run maintenance plans.
File location
Delete specific file
Delete the specific file defined in the File name field.
File name
Type in or use the 
button to specify the path to the file to be deleted.
Delete files in specific folder by extension
Delete all files with the specified extension in the specified folder. Use this to delete multiple files at once.
Folder name
Type in or use the button to specify the path to the folder containing the files to be deleted.
File extension
Provide the file extension of the files to be deleted. If you have chosen Backup files in the File types to remove group then the default is *.bak. If you have chosen Maintenance plan reports then default file extension is *.txt.
Include first level subfolders
Delete files with the extension specified for File extension from first-level subfolders under Folder.
File age
Delete only files that are older than
Specify the minimum age of the files that you want to delete by providing a number, and unit of time (Hour, Day, Week, Month, or Year). Files older than the time frame specified will be deleted.
See also:
