Export (0) Print
Expand All

Maintenance Plan Wizard (Define History Cleanup Task Page)

Use the Define History Cleanup Task page to discard old task history. This task deletes the records of when certain types of jobs occurred.

This statement uses the sp_purge_jobhistory, sp_maintplan_delete_log, and sp_delete_backuphistory statements to remove history information from the msdb tables.

Backup and restore history

Retaining records of when recent backups were created can help SQL Server create a recovery plan when you want to restore a database. The retention period should be at least the frequency of full database backups.

SQL Server Agent Job history

This history can help you troubleshoot failed jobs, or determine why database actions occurred.

Maintenance Plan history

This history can help you troubleshoot failed maintenance plan jobs, or determine why database actions occurred.

Remove historical data older than

Specify age of items that you want to delete.

Community Additions

ADD
Show:
© 2015 Microsoft