just for clarification sp3 + cu1

  • Hi,

    if i have sql server 2005 with sp2 installed and i want to install sp3,i need to install the sp3 first and then the sp3 cu1 to be up to date?

    because sp3 not include the sp2 cu10 and cu11.

    THX

  • Yes and no. SP3 is a rollup of hotfixes, but because of the delays in testing it, there were fixes that got into CU 10 and CU 11 that didn't make SP3.

    IF you need those fixes, or had applied them to your SP2 machine, then you need CU1. If not, I'm not sure that I would go with CU1. SP3 provides a well tested patch, whereas the CUs are not extensively tested. There is testing on the patch, but not complete regression as there is with SPs.

    So technically there are not any patches beyond SP3+CU1, but if you do not specifically need that, I'm not sure I'd apply CU1.

  • I am also looking at SP3 installation, and was wondering the same thing about CU10 and CU11. Is there a way to verify if these updates were applied?

    I have run the following statement against one of my development servers, with these results:

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    Results:

    9.00.3077.00SP2Standard Edition (64-bit)

    That doesn't really tell me if CU10 or CU11 were ever applied, since I don't know what product version would have been associated with those fixes.

    Based on the MS Release Notes for SP3, unless CU10 or CU11 were applied, you don't need to apply CU1 after SP3. I'm guessing we fall into the category of not needing to apply the extra CU1 fix.

    I should add that I'm new to the DBA role in our company and previous versions of SP's have been installed by a server admin, who has indicated he is unfamiliar with the terms CU10 or CU11. Any advice?

    Thanks!

  • It doesn't look CU 10 or CU 11 were applied:

    Check for "Build 09.00.3077" at

    -->http://support.microsoft.com/default.aspx/kb/937137/en-us#

    MJ

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

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