Microsoft has issued a critical update for SQL Server 2005 SP2 Workgroup edition and higher. The update does not apply to SQL Server 2005 Express Edition (SSX).
According to Knowledge Base article 933508, Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended:
If you apply the initial release version of Microsoft SQL Server 2005 Service Pack 2 (SP2), existing SQL Server 2005 maintenance plans and Integration Services packages that contain cleanup tasks run those tasks at shorter intervals. The issue occurs only if all the following conditions are true:
- You downloaded SQL Server 2005 SP2 before March 05, 2007, and installed that download package.
- You use SQL Server 2005 maintenance plans or Integration Services packages.
- Those plans or packages include History Cleanup tasks or Maintenance Cleanup tasks.
The resolution for this issue is described in the "Resolution" section.
Users of SQL Server 2000 legacy maintenance plans and users who downloaded SP2 after March 05, 2007 are not affected. On this date, SQL Server 2005 SP2 was refreshed to include an update that avoids this issue.
Note This problem only affects the main SQL Server 2005 SP2 packages. These packages use the following naming convention:
This problem does not affect SQL Server 2005 Express Edition or SQL Server 2005 Feature Pack packages.