| Author |
Topic |
|
Van
Constraint Violating Yak Guru
462 Posts |
 Posted - 2009-04-02 : 10:26:56
|
| I'm new to clustering with sql and just had a quick question. I've installed SP3 for SQL 2005 on the active node. I rebooted and the passive node became active (expected). Now do I still need to install SP3 on the passive (now active) node or did the original install take care of both?Thanks,Van |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-02 : 10:55:08
|
| Is it single instance cluster or multi-instance cluster?If its single instance, you should still install client tools and other stuff (check everything in the list except database services..actually the database services will be disabled on passive node)If its multi-instance and the node is active, install everything in SP3.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-04-03 : 10:41:28
|
| Microsoft SQL Server Serice P's are cluster aware means while installation it detects Cluster components/features and updates them. When you run it passive node select only those features which are'nt cluster aware. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-03 : 11:10:46
|
| Is there any harm on running the full install on all nodes in a cluster? |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-04-03 : 13:22:35
|
| I don't know, never tested this scenario. |
|
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-04-06 : 14:32:53
|
| Recently I did cluster upgrade. I ran install on only one Node and also applied sp to only one node. Since install is cluster aware it upgraded all nodes. Only thing important is you should log in as cluster administrator to do the install. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-07 : 10:25:07
|
quote:
Originally posted by kumarich1
Recently I did cluster upgrade. I ran install on only one Node and also applied sp to only one node. Since install is cluster aware it upgraded all nodes. Only thing important is you should log in as cluster administrator to do the install.
SP will not update the client tools on the passive node. you need to do that manually.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-04-07 : 12:34:12
|
quote:
Originally posted by dinakar
quote:
Originally posted by kumarich1
Recently I did cluster upgrade. I ran install on only one Node and also applied sp to only one node. Since install is cluster aware it upgraded all nodes. Only thing important is you should log in as cluster administrator to do the install.
SP will not update the client tools on the passive node. you need to do that manually.We don't have client tools installed on passive node. Our database files are residing on shared drive.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
|
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-07 : 12:37:43
|
quote:
Originally posted by kumarich1
quote:
Originally posted by dinakar
quote:
Originally posted by kumarich1
Recently I did cluster upgrade. I ran install on only one Node and also applied sp to only one node. Since install is cluster aware it upgraded all nodes. Only thing important is you should log in as cluster administrator to do the install.
SP will not update the client tools on the passive node. you need to do that manually.We don't have client tools installed on passive node. Our database files are residing on shared drive.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
Sure the database files are on a shared drive. I am talking about client tools - Management Studio.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
jmbone
Starting Member
4 Posts |
Posted - 2009-10-06 : 09:32:00
|
| What is the procedure for installing SP3 on the passive node? (to get the pieces that are not cluster aware).Is there some Microsoft documentation on this? The install notes for SP3 for a cluster do not mention running the install on the passive node. Jana |
|
|
|
|
SQL 2005 Cluster SP3 install