September 30, 2013 at 9:56 am
Hi,
We have active active sql 2008 r2 running on Win 2008 r2 cluster.
Instance_A is running on Node1
Instance_b is runing on NOde2
Due to Os issue , NOdeA Crashed and Wintel Team want to re-install the O.S and cluster on NODEA only.
While building the SQL server in initial stage we have followed the below way:
For Instance A, we have ran the Main setup on NodeA and then added node on NOdeB
For Inctanse B, we have ran Main setup on NodeB and then Added Node on NodeA
NOw Node A ,is down both sql i running on Node B.
If Node A is re-building then ,how to add this node to sql instance ?
As per sql prospect how we have to do installation and what are steps we need to follow.
Please help me. It is very urgent
Your help much appreciated...
Thank you in advance....
October 1, 2013 at 6:24 am
Not difficult to do,
1. first within failover manager remove NodeA as a possible owner from the cluster group for your SQL Instances.
2. Then remove the node form the windows cluster.
3. Reinstall Node A's OS
4. On node A, run the SQL Server install and select the option to add a node to a cluster.
5. Patch your A Node to the same Service pack \ Cumulative update as the B node.
6. Failover and failback to ensure normal operation.
MCITP SQL 2005, MCSA SQL 2012
October 1, 2013 at 6:28 am
PS, worth mentioning that its been a while since I did this last, so may have missed something, but that should cover what you need.
MCITP SQL 2005, MCSA SQL 2012
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply