Subscribe to this blog
Briefcase
Print
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
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).