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.

 

Maintenance plans - Maintenance Plan Editor - Managing tasks - Clean up maintenance log

 

 

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

!RadioButton Backup files

Delete SQL Server backup files.

 

!RadioButton Maintenance plan reports

Delete text reports of previously run maintenance plans.

 

File location

!RadioButton Delete specific file

Delete the specific file defined in the File name field.

 

File name

Type in or use the OpenFile button to specify the path to the file to be deleted.

 

!RadioButton 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 OpenFile 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 !RadioButton Backup files in the File types to remove group then the default is *.bak. If you have chosen !RadioButton Maintenance plan reports then default file extension is *.txt.

 

!CheckBox Include first level subfolders

Delete files with the extension specified for File extension from first-level subfolders under Folder.

 

File age

!CheckBox 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:

Backup database

Check database

Rebuild indexes

Reorganize indexes

Shrink database

Update statistics

Execute job

Execute T-SQL statement

Notify operator

Clean up history

Precedence constraints