Tuesday, March 6, 2007

SQL Server SP2 Re-Released!

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.