Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server @@VERSION on 2 node failover cluster.


SQL Server @@VERSION on 2 node failover cluster.

Author
Message
alanspeckman
alanspeckman
SSC-Enthusiastic
SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)

Group: General Forum Members
Points: 104 Visits: 766
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?
joffwilliams
joffwilliams
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 221
@@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.
sql-lover
sql-lover
SSChasing Mays
SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)

Group: General Forum Members
Points: 651 Visits: 1930
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
alanspeckman
alanspeckman
SSC-Enthusiastic
SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)

Group: General Forum Members
Points: 104 Visits: 766
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.
sql-lover
sql-lover
SSChasing Mays
SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)

Group: General Forum Members
Points: 651 Visits: 1930
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?
alanspeckman
alanspeckman
SSC-Enthusiastic
SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)

Group: General Forum Members
Points: 104 Visits: 766
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.
alanspeckman
alanspeckman
SSC-Enthusiastic
SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)

Group: General Forum Members
Points: 104 Visits: 766
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search