| Author |
Topic |
|
hannah00
Starting Member
31 Posts |
 Posted - 2007-07-11 : 09:20:07
|
| If I have SQL cluster: ACTIVE/ACTIVE mode and let's say node A is crashed and we have to rebuild a new server, what are the steps that I need to take to bring the new node to the cluster, below is what I have in mind:1. re-install OS2. re-add the new node to the clusterand I am not sure if I have to re-install SQL on this new node. Please give me some details of steps of how to do it.thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-11 : 12:59:51
|
| You will need to reinstall the instance as it won't be aware of the new node.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-11 : 14:32:50
|
| Sql2k installation has option to add/remove node, didn't get chance to try sql2k5 installation. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-11 : 14:41:19
|
| Yes and that's what I'm referring to. The add/remove node actually does an installation as it has to install the software and engine on the new node since it won't exist there.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
dchriste
Starting Member
2 Posts |
Posted - 2007-09-06 : 00:13:32
|
| I have the same issue. From what I understand, all I need to do is install SQL on the node that was just rebuilt, and add the node to the cluster? The SQL instance get's installed when we add it to the cluster, right?Am I correct?Dwight |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-06 : 00:46:51
|
| No. You add the node to the cluster then run the setup to install SQL on the new node.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
dchriste
Starting Member
2 Posts |
Posted - 2007-09-06 : 10:44:56
|
| Sorry for the stupid question, but will that affect the other node while it's up? I'd really like to do this without causing any downtime... if possible.Thank you for the reply.Dwight |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-06 : 11:39:53
|
| You'll probably need to reboot both nodes.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-06 : 14:45:36
|
| you'll need to reboot them atleast for the service packs and test if they fail over to each other so downtime is unavoidable--------------------keeping it simple... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-06 : 14:47:53
|
| this information is also in books online (BOL) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-06 : 22:33:47
|
| Adding node doesn't affect existing instance, but you need failover to new node to apply sp. May stuck there, still try to figure out how to process that. |
|
|
|
squison
Starting Member
4 Posts |
Posted - 2007-09-19 : 09:50:51
|
| See this link on add/removing nodes from a SQL cluster:http://msdn2.microsoft.com/en-us/library/ms191545.aspxYou may run into some issues when trying to add the node back as a viable node for SQL since it wasn't cleanly removed from the failed node. I've done this once before but I'm having trouble finding the howto link.As for service packs, you won't need to install them for the database engine as that follows the virtual server.. but if you want the client tools/SSIS, etc (the non-clustered components) on the newly installed node, you'll need to run the setup on that node to install them and then upgrade them to the correct service pack. None of that should touch the database engine, especially if it's running on the other node. The only downtime I see is if you want to (and you should) fail things around and make sure everything works after you're done. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-19 : 23:26:41
|
| >> As for service packs, you won't need to install them for the database engine as that follows the virtual server.Not the case in my several adding node works, sql engine has no sp once failover to new node. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-19 : 23:31:29
|
| rmiao, If your SQL instance doesn't report the same version on each of the nodes, then you've got something wrong. squison is correct when he says it follows the virtual server and that the other tools require you to install the packs/patches on each node. You should contact MS if this is not the case on your cluster.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
SQL CLuster: ACTIVE/ACTIVE mode