Groups | Blog | Home
all groups > sql server clustering > january 2007 >

sql server clustering : Dual Node 64 bit 2005 Cluster, different SP levels


Padraig
1/25/2007 9:13:51 AM
Hi Guys,

Have a weird one. I was running windows update on my nodes.
My passive node reports that it needs SP1
My active node doesnt need it .

Any ideas.

Edwin vMierlo
1/25/2007 5:23:08 PM
Dear Pádraig,

So the questions you need to answer are:
- is SP1 installed on Node-1 ?
- is SP1 installed on Node-2 ?

You must be in control of what is installed on your cluster nodes, both
Service pack as well as hotfixes and security fixes, if you don't have an
administration for this, I strongly suggest you start this. You cluster must
be fully documented, that should be part of your HA strategy. To be honest,
I would not *just* rely on "Windows Update" to manage the service packs or
updates on a cluster.

bottom-line, your service pack level MUST be the same on both nodes

rgds,
Edwin.



[quoted text, click to view]

Padraig
1/26/2007 12:46:00 AM
I totally agree.

I thought I had applied SP1 was on both nodes.
Whats the best way to check for sure that SP1 is on both nodes ?

[quoted text, click to view]
Padraig
1/26/2007 6:41:02 AM
Sorry Edwin,

I should have been clearer, it is my SQL 2005 that reports the different SP
levels.

My Op system is 2003 SP1 on both nodes.

[quoted text, click to view]
Edwin vMierlo
1/26/2007 10:07:35 AM
Right-click on "My Computer", choose "Properties"
On the "General" tab it should list the OS, version, edition and service
pack.




[quoted text, click to view]

Edwin vMierlo
1/26/2007 2:50:56 PM
full article : http://support.microsoft.com/kb/321185

How to determine which version of SQL Server 2005 is running
To determine which version of Microsoft SQL Server 2005 is running, connect
to SQL Server 2005 by using SQL Server Management Studio, and then run the
following Transact-SQL statement:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')The results are: . The product version (for
example, "9.00.1399.06").
. The product level (for example, "RTM").
. The edition (for example, "Enterprise Edition").
For example, the result looks similar to: 9.00.1399.06 RTM Enterprise
Edition
The following table lists the Sqlservr.exe version number: Release
Sqlservr.exe
RTM 2005.90.1399
SQL Server 2005 Service Pack 1 2005.90.2047




HTH,
_Edwin.


[quoted text, click to view]

AddThis Social Bookmark Button