SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server 2005 SP2 and Maintenance Plans - Still not fixed yet

SQL Server MVP Aaron Bertrand has posted that there is still a bug with maintenance plans for SQL Server 2005 SP2. There looks to be another release coming to fix the issue. More here:

  More news on Service Pack 2 and Maintenance Plans

His advice is that if you're holding off applying SP2 because of the maintenance plan issue, hold off a little longer. If you've applied SP2 and you're thinking about applying the hotfix documented in KB article 933508, it may be a good idea to wait on that as well. I had just downloaded the hotfix to apply to one of my servers when I noticed Mr. Bertrand's post. I see that 933508 has been updated as of today, but I don't know what was updated on it, so I'm going to wait a couple of weeks to see what shakes out. As to what to do with 933097, a cumulative update for SQL Server 2005 SP2, I'll play the wait and see game there, too.

Technorati Tags: SQL Server | Microsoft SQL Server | SQL Server 2005 | SQL Server 2005 Service Pack 2

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.


Posted by Aaron Bertrand on 15 March 2007
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).
Leave a Comment

Please register or log in to leave a comment.