Which Service Pack?? 1

[sqlsadie108]

Hi,

The Microsoft web site gives 3 choices of SP2.

I have no idea which version is the correct on for our server. Can someone please explain to me how I can determine which service pack to download?

THANKS

SQLServer2005SP2-KB921896-IA64-ENU.exe
SQLServer2005SP2-KB921896-x64-ENU.exe
SQLServer2005SP2-KB921896-x86-ENU.exe

 

[gmmastros]

If you run (in a query window)...

select @@Version

You may see [!](intel x86)[/!] as part of the output if so... then you'll want:

SQLServer2005SP2-KB921896-[!]x86[/!]-ENU.exe

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mrdenny]

x86 would be for 32bit systems
x64 would be for 64bit systems such as Intel and AMD.
IA64 would be for 64bit Itanium processors. You would know if you had these they are like 4 times more expensive than Intel or AMD 64bit processors.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

And make sure you are downloading the LATEST version of SP2. The date will be later than Mar 5th.

-SQLBill

Posting advice: FAQ481-4875

 

[sqlsadie108]

shoot, i installed the one from 2/7

should i bother downloading the one from ptheirault's link and re-do?

 

[mrdenny]

If you can I'd get the newer one. I'm redeploying it to all out systems now.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

The only problem is that Microsoft says you cannot apply SP2a if you already have SP2 applied. There is a fix to apply to the SP2 if you have that installed.

Reference:

http://support.microsoft.com/kb/933508/en-us

Note If you try to apply the SP2 refresh over a previous SP2 installation, no files are updated. Instead, use the general distribution release (GDR) update below.

If you downloaded SQL Server 2005 SP2 before March 05, 2007
If you downloaded SQL Server 2005 SP2 before March 05, 2007, apply the general distribution release (GDR) update for those SQL Server 2005 SP2 installations. The GDR update is available at the Microsoft Download Center:
Critical Update for SQL Server 2005 Service Pack 2 (

http://go.microsoft.com/fwlink/?LinkId=85124)

-SQLBill

Posting advice: FAQ481-4875

 

[sqlsadie108]

Thanks SQLBill, et al

So you're saying that I should 1.) apply the fix to SP2 already installed, 2.) then get the critical update from (

http://go.microsoft.com/fwlink/?LinkId=85124)

yes?

 

[SQLBill]

The fix I mentioned is the Critical Update. While I suggest it get applied, here is what it really does....

SP2 'messed' up maintenance plans. In a maintenance plan, you can set how long to keep the files. SP2 sets the value to 1 HOUR by default. The Critical Update fixes that. If you don't use maintenance plans, or check them and ensure they have the correct values...then you may not really need the critical update. But it wouldn't hurt anything to apply it anyways.

-SQLBill

Posting advice: FAQ481-4875