Maintenance plan changes in SQL Server 2005 SP2 – cleanup interval for history cleanup task / maintenance cleanup taks is now based on hours

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


http://blogs.msdn.com/sqlrem/archive/2007/02/24/Maintenance-Plan-Changes-in-SQL-Server-2005-SP2.aspx

2 thoughts on “Maintenance plan changes in SQL Server 2005 SP2 – cleanup interval for history cleanup task / maintenance cleanup taks is now based on hours”

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>