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
srinivas_ganamurAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kruger_monkeyCommented:
Are you applying this CU because you have some of the problems that it fixes?

The path for export should be anything c:\temp for example.  I've not installed this CU directly but normally the path is a temporary one.

Looking at you screenshot in step 4 it would appear that you don't have all the necessary files.  It is saying it it part of a multipart archive.  That indicates you are missing another archive file.  Can you verify that you have all of the necessary files, or that the file is not corrupt.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
srinivas_ganamurAuthor Commented:
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)).
0
Kruger_monkeyCommented:
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..  
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

srinivas_ganamurAuthor Commented:
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?
0
Kruger_monkeyCommented:
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.

0
srinivas_ganamurAuthor Commented:
Hi Kruger,

that is OS service pack.

use below query to check latest sql server service pack:

select serverproperty('productlevel'),serverproperty('productversion'),serverproperty('edition')
0
Kruger_monkeyCommented:
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. :)

0
srinivas_ganamurAuthor Commented:
--
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.