THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Aaron Bertrand

Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at since 2006, focusing on manageability, performance, and new features, and also blogs at and; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

More news on Service Pack 2 and Maintenance Plans

So I have official word (and permission to broadcast) that there is one minor bug left in maintenance plans, in the wake of last week's difficulties in properly addressing SP2 and the fixes that followed.  We should expect a GDR early next week and a QFE rollup within a week of that.  No, I don't have build numbers yet, and no, I don't know exact dates.  But if you're using maintenance plans and have held off installing SP2 or the followups until now, wait until the GDR is released.  I will try to stay on top of it, and will publish something here as soon as I hear anything.
Published Thursday, March 15, 2007 2:42 AM by AaronBertrand



AaronBertrand said:

A comment I posted on K. Brian Kelley's blog (you'd have to read his entry for context, but basically he observed that was updated today):

I think they only updated the article with more disclosure about what actually happened... I'm fairly confident the actual bits in the hotfix there (and the 3152 QFE) remain unchanged, and the final minor issue we have will be resolved within 7 days (GDR) and 14 days (QFE rollup).

If you watched the SP2 download page on the Friday when the issue was first fixed, they quietly swapped out the executable instead of providing full disclosure (personally, I think they should have pulled the download).  I think they're owning up to that now, but I can understand they still have a hard time reaching all of the people who downloaded the service pack prior to the issue being discovered (and many of those may not have even installed the service pack yet).

March 15, 2007 1:19 PM

Chris Wood said:


I notice this fix includes an update to Microsoft.sqlserver.maintenanceplantasks.dll

Maybe your fix is getting closer to be published.


April 4, 2007 2:57 PM

AaronBertrand said:

Thanks, there are two new builds, 3054 and 3159, which one you are supposed to apply depends on what you have now.  Really, really messy.  I posted details on both in a new entry before I saw these comments.



April 4, 2007 9:56 PM

Aaron Bertrand said:

Back in June, I told you about a post-SP3 CU that was released for SQL Server 2005: Cumulative Update

August 6, 2009 11:06 PM
New Comments to this post are disabled

About AaronBertrand

...about me...

This Blog



Privacy Statement