September 9, 2013 at 5:08 am
Hi All,
Just looking for a bit of clarification on the steps i need to take to add a node to a 2-node sql server 2008 cluster.
2-node cluster with three instances (instance1 , instance2 & instance3) installed
The steps i was considering are :
1. Infrastructure team build new server and add the new node to the failover cluster at a windows level.
2. Run the Add node to the failover cluster option and select instance1
3. Apply Service Pack 2 to instance1
4. Check instance1 can failover to the new node
5. Repeat steps 2,3 & 4 for instance2 and instance3
Does that seem like a o.k plan ?
Many thanks
September 9, 2013 at 11:47 pm
Hi,
The steps are :
1. Add Node3 to the MSCS Cluster
2. Add Node3 to the instance1 With SQL Server Installer. It is active on Node1 or Node2
3. Apply Service Pack To Node1
4. Failover Instance1 to Node1 for validation
5. Do the same for the other instances.
Best Regards
September 11, 2013 at 3:18 am
Sorry
Point 3. is Apply SP to Node3
September 11, 2013 at 4:21 am
You could wait with the installation of SP untill you have added the node-installation of all three SQL instances. After the installation of all three SQL instances you can apply the SP (on the third node) to all three instances at once.
1. add server to WFSC at OS level
2. install first SQL instance on node with 'add node' installation
3. install second SQL instance on node with 'add node' installation
4. install third SQL instance on node with 'add node' installation
5. install SP on third node and apply to all three instances
September 11, 2013 at 4:29 am
ft55 (9/9/2013)
The steps i was considering are :1. Infrastructure team build new server and add the new node to the failover cluster at a windows level.
2. Run the Add node to the failover cluster option and select instance1
3. Apply Service Pack 2 to instance1
4. Check instance1 can failover to the new node
5. Repeat steps 2,3 & 4 for instance2 and instance3
Does that seem like a o.k plan ?
Many thanks
Ensure that the server OS build has the same patch level as the existing nodes.
Ensure that all storage has been presented to the new node and that the cluster validation is successful.
Either create a drop merged SQL Server installer with the correct SP or slipstream the SP and\or CU at install time when running the Add Node. See my article here[/url] for slipstreaming updates during the install.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply