As noted in an earlier post, SQL Server 2005 SP2 shipped with some problems around the maintenance jobs and how the schedule works. (For more information, see the following KB article: http://support.microsoft.com/kb/933508)
If you have already installed the SQL 2005 SP2
Install the General Distribution Release (GDR) on top of that build to fix the problem. No un-installation of the old SP2 needed.
GDR download location:
http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en
If you have not upgraded to SQL 2005 SP2 official release:
- Download the new SP2 consolidated package at:
o http://www.microsoft.com/downloads/details.aspx?FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en
o This SP2 (9.00.3042.00) includes the fix for the database maintenance job problem we identified on the SP2 build that was released on Feb. 19th, 2007.