History Cleanup Task

• DoubleD

  SSC-Addicted

  Points: 430

  More actions

  January 9, 2008 at 2:24 pm

  #119928

  Can anyone explain the scope of a History Cleanup Task?

  Does it clean up the history only for the database(s) covered in a given plan, or does it simply execute sp_delete_backuphistory without regard to the database(s)?

  For example, if I have one maintenance plan to backup database A with a History Cleanup Task set to delete history older than one week, and another plan to backup database B with a History Cleanup Task to delete history older than one month, would there be any history left on the instance older than one week, assuming both plans were ran with the same frequency?

  If it is universal in scope then I would expect that only one cleanup task is most likely to be needed for a given instance.

  Any thoughts?

  Thanks!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  January 9, 2008 at 3:09 pm

  #766419

  It just runs sp_delete_backuphistory.

  You can profile it, but the easiest thing to do is hit the View T-SQL button on the task. It shows you what runs.