SQL Server 2005 SP2 Refresh

The initial release of SQL Server 2005 Service Pack 2 (SP2) contained an issue that caused maintenance plan cleanup tasks to remove data before the specified cleanup interval. Install this update to correct the interpretation of existing cleanup task intervals, and to avoid this issue in new cleanup tasks. After you install this item, you may have to restart your computer.

If you already installed the SQL 2005 SP2 released on Feb. 19^th, 2007:

• Install the General Distribution Release (GDR) on top of that build to fix the problem.  No un-installation of the old SP2 is 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:

• Microsoft has released the refreshed SQL 2005 SP2 at Microsoft Download Center last night (March 5^th, 2007):
  
  • http://www.microsoft.com/downloads/details.aspx?FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en
    
  • This SP2 (9.00.3042.00) includes the fix for the database maintenance job problem Microsoft has identified on the SP2 build we released on Feb. 19^th, 2007.
    

The updated SP2 doesn’t fix the RS black preview issue for which a separate hotfix will be available at later time.