In SQL Server 2005 SP2, cleanup interval for the History Cleanup Task or the Maintenance Cleanup Task of SQL Server 2005 SP2 maintenance plans are specified in hours.
After installing SP2 *on SQL Server 2005*, you will need to adjust the age units of the cleanup tasks using Maintenance Plan Designer (of SQL Server 2005 *SP2 tools*). Otherwise, intervals existing cleanup tasks will be misinterpreted, and the data cleanup will be made earlier than what was intended.
If you have *not* installed SP2 on SQL Server 2005, while you depend on the Maintenance Cleanup Task or the History Cleanup Task, you are suggested to use matching server and tool versions. (E.g., To use SP1 tools on SQL Server 2005 with SP1 applied.)
Note: This does *not* affect SQL Server 2000 legacy maintenance plans.
===== For more information =====
- Maintenance Plan Changes in SQL Server 2005 SP2