Biml - History Cleanup Task
The History Cleanup Task is another of those Database Maintenance tasks that I never use. It requires an ADO connection manager and allows you to cleanup any combination of backup and restore history, SQL Server Agent history and Maintenance plan history.
<Biml xmlns="http://schemas.varigence.com/biml.xsd"> <Connections> <AdoNetConnection Name="CM_ADO_DB" ConnectionString="Data Source=localhost\dev2012;Integrated Security=SSPI;Connect Timeout=30;Database=msdb;" Provider="SQL" /> </Connections> <Packages> <Package ConstraintMode="Linear" Name="Task_HistoryCleanup"> <Tasks> <!-- Look busy without doing anything --> <HistoryCleanup ConnectionName="CM_ADO_DB" Name="HC Clean as my children do" OlderThanTimeUnits="4" OlderThanTimeUnitType="Weeks" RemoveBackupRestoreHistory="false" RemoveDBMaintenanceHistory="false" RemoveSqlAgentHistory="false" /> </Tasks> </Package> </Packages> </Biml>
A package is created with our ADO.NET connection manager and a single Cleanup History task.
HC Clean as my children doa
I've configured the History Cleanup task to do nothing.
I love that it actually warns you of this as you click the View T-SQL button