asked on

Sql server 2005 - Sp3 installation

I am upgrading sql server 2005 sp2 to sp3. So i have downloaded sp3 from below link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

(SQLServer2005SP3-KB955706-x86-ENU.exe).

After downloading, i have successfully installed sp3. After that i have downloaded CU#1of MS SQL 2005 SP3. At the time of installation it was asking "Select the where you want to unzip the file". Please let me know here which path/folder i have to select to proceed.

Please find the attached screen shots of CU#1 hot-fix extractor.
CU-1-Step1.bmp
CU-1-Step2.bmp
CU-1-Step3.bmp
CU-1-Step4.bmp

ASKER CERTIFIED SOLUTION

Kruger_monkey

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

srinivas_ganamur

ASKER

I have not missed any files. In Microsoft help center, it is clearly mentioned, from sp2 to sp3 upgrade ....we have to install first SP3 and after that we have to install CU#1 of SP3 (Sp3--Cu#1=CU#10 (SP2)+CU#11(SP2)).

Kruger_monkey

What I meant was for CU#1 of SP3 are you missing any parts of the zip file, or have you tried re-downloading the file.

In your last graphic(step4), that warning indicates that it is expecting another archive part. I.E. It is expecting something like CU#1.part1 (which you have) when that extracts it gets to a point and then expects CU#1.part2 (which you don't have). Does that makes sense.

I know you have installed SP3 and all the necessary updates that CU#1 requires, but it looks like your CU#1 download, is either missing a file or is corrupt, try re-downloading and then try it again..

srinivas_ganamur

ASKER

i have successfully installed SP3 & CU#1 of Sp3 on my development server. But it was still showing SP2.

select @@version

output:
Microsoft SQL Server 2005 - 9.00.4207.00 (Intel X86) Dec 17 2008 14:34:38 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2).

is there any extra patches i have to apply?

Kruger_monkey

I've just checked mine and I definately have SP3 installed. I checked both of my servers which both have sp3 installed and both are showing SP2. Probably just a MS quirk.

srinivas_ganamur

ASKER

Hi Kruger,

that is OS service pack.

use below query to check latest sql server service pack:

select serverproperty('productlevel'),serverproperty('productversion'),serverproperty('edition')

Kruger_monkey

Wow, I'm sleeping a lot today. Should have noticed that. Yes, the serverproperty query displays sp3. Are you saying that yours still shows SP2, or did we both make the same mistake. :)

srinivas_ganamur

ASKER