History Cleanup Task

The history cleanup task deletes entries in the following history tables in the sql server msdb database.

·         Backupfile

·         Backupfilegroup

·         Backupmediafamily

·         Backupmediaset

·         Backupset

·         Restorefile

·         Restorefilegroup

·         Restorehistory

By using the history cleanup task, a package can delete historical data related to backup and restore activities, sql server agent jobs, and database maintenance plans.

Step 1:

Drag and drop history cleanup task and edit it.

Step 2:

Give a new connection as History Cleanup Task

Step 3:

Select the historical data to delete

Step 4:

Click on view T-SQL

Step 5:

Execute a task