Post reply

KB970894 Accidentally applied, Is this cumulative?

  • October 19, 2009 at 1:17 pm

    #205793

    Typically, I will control all upgrades that occur to my development, QA and production SQL Server environments. Some may see this is anal retentive, but in my mind this is the way it has to be in order to ensure that all code is developed and tested under the same SQL Server release in which it will be deployed.

    I am currently running SQL Server 2005 SP3 CU2 in our production environments (9.0.4211 X64).

    I have recently started to install (stage) SQL Server 2005 SP3 CU4 (9.0.4266) to some of our development and QA servers to address a problem that we are having in production. The plan was to deploy SP3 CU4 to our productions servers somewhere in the next 2 weeks.

    Over the weekend our IT staff accidentally applied a SQL Server Security patch (kb970894) to one of our production Log Ship Servers which was originally patched to SP3 CU2. The build version now shows 9.0.4262 on the Log Ship server.

    Can someone tell me if this is a cumulative patch? In other words, there are critical patches that I need from SP3CU4 and I need to know if these critical patches are included when applying this security patch directly without applying SP3CU4or5.

    If these security patches are cumulative, then I will plan on installing KB970894 to all of my development and testing/QA environments immediately and roll it out to my remaining production servers after two weeks of testing.

    Does anyone see a flaw in my logic?

    Thank You

  • October 19, 2009 at 2:00 pm

    #1067825

    Hi Eric,

    The patches are cumulative, so after you install the latest security update, you server has now all the fixes, including CU4,CU5 and the latest hotfix.

    http://support.microsoft.com/kb/960598

    Regards,

    Jose Santiago Oyervides.

  • October 19, 2009 at 3:23 pm

    #1067850

    Jose...thank you, this is what I expected but I just wanted to make sure.

    I could not find any documentation that explained that a security patch was cumulative.

    This patch falls between the SP3CU5 and SP3CU6 builds but it is not documentated as a cumulative update....very confusing!

    Thanks Again

    Eric

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply