?
Solved

Sql server 2005 - Sp3 installation

Posted on 2010-03-29
8
Medium Priority
?
561 Views
Last Modified: 2013-12-05
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
0
Comment
Question by:srinivas_ganamur
  • 4
  • 4
8 Comments
 
LVL 8

Accepted Solution

by:
Kruger_monkey earned 500 total points
ID: 28965992
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
 

Author Comment

by:srinivas_ganamur
ID: 28966717
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
 
LVL 8

Expert Comment

by:Kruger_monkey
ID: 28968606
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:srinivas_ganamur
ID: 29078384
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
 
LVL 8

Expert Comment

by:Kruger_monkey
ID: 29179889
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
 

Author Comment

by:srinivas_ganamur
ID: 29181989
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
 
LVL 8

Expert Comment

by:Kruger_monkey
ID: 29201010
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
 

Author Closing Comment

by:srinivas_ganamur
ID: 31708278
--
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found here: http://www.experts-exchang…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question