Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server @@VERSION on 2 node failover cluster. Expand / Collapse
Author
Message
Posted Tuesday, November 13, 2012 9:07 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 10:19 AM
Points: 86, Visits: 539
Is there a server property I can use to find out the version of SQL Server installed on a 2 node cluster?

I recently had a situation where there was a SQL 2008 RTM cluster with one node being at SP1 and the other node bing at SP3, but querying @@Version showed SP3. How can I tell what version each node of a cluster is on?
Post #1384144
Posted Tuesday, November 13, 2012 10:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, February 10, 2014 4:19 PM
Points: 97, Visits: 174
@@version will report the version of the node currently serving the instance. I believe you would need to fail over the SQL Server instance cluster service to the node you want to query the version of.
Post #1384191
Posted Tuesday, November 13, 2012 10:36 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:27 PM
Points: 302, Visits: 1,068
SQL 2008 Cluster setup needs to be run twice (on a two node cluster) So you will end with two binaries install, one per node. This is different from SQL 2005 where it was just one setup that runs over the network, but prone to issues in case of missing dlls or stuff not properly copied (actually happened to me one time, long time ago, ugly experience detected almost a year later)

For that reason, I believe you need to fail over the passive node, become active, and run

SELECT @@VERSION
Post #1384195
Posted Tuesday, November 13, 2012 11:05 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 10:19 AM
Points: 86, Visits: 539
A bladelogic scan indicated one node of the server was at SP1. After I failed this test server over, I was able to see SP1. I just wondered if there was a way for me to tell if both nodes in the cluster are at the same SP/patch level without failing over.

SQL 2005 I always installed on Active node, and I experienced the same problem as you with the passive node not getting all the updates. I like SQL 2008 much better, maintains availablity in the process.
Post #1384205
Posted Tuesday, November 13, 2012 11:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:27 PM
Points: 302, Visits: 1,068
alanspeckman (11/13/2012)
A bladelogic scan indicated one node of the server was at SP1. After I failed this test server over, I was able to see SP1. I just wondered if there was a way for me to tell if both nodes in the cluster are at the same SP/patch level without failing over.

SQL 2005 I always installed on Active node, and I experienced the same problem as you with the passive node not getting all the updates. I like SQL 2008 much better, maintains availablity in the process.


Agree! SQL 2008 was a step forward.

Do not trust me on this, I need To Validate. But maybe you can right click a exe or dll inside the binaries, each node, and check version?
Post #1384224
Posted Tuesday, November 13, 2012 3:01 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 10:19 AM
Points: 86, Visits: 539
I'm looking for more of a script where I specify the node of a cluster and it tells me what version of sql it currently sits at.
Post #1384322
Posted Tuesday, November 13, 2012 3:37 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 10:19 AM
Points: 86, Visits: 539
Found this. Could get server names in cluster, then run the last script for each node name in cluster and get the versions.

http://powershellcommunity.org/Forums/tabid/54/aft/7885/Default.aspx

Get-WmiObject sqlserviceadvancedproperty -namespace "root\Microsoft\SqlServer\ComputerManagement10" -computername $env:computername | Where {@("SKUNAME","VERSION") -contains $_.PropertyName } | SELECT __SERVER, PropertyStrValue

Works in SQLPS, will have to test at home.
Post #1384331
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse