June 11, 2009 at 9:50 am
I recently set up a cluster consisting of two nodes each running SQL Server 2005 on 2 Windows Server 2008 Boxes. At the time, the 2 nodes were already added to the cluster and configuration was set up correctly, then I installed SQL server cluster for both nodes at the same time. The Cluster has worked with no problems, now we decided to remove the second node from the cluster and add a new node that matches the first node performance. My question is about adding the second node: do I need to install SQL Server separately on the second node (Binaries) and then run the following steps or do the steps below take care of it? I assume that once the steps below complete, I will need to install client workstation components on the new node and SP3. I would appreciate any clarification.
1.Double-click Add or Remove Programs in Control Panel.
2.Select the SQL Server 2005 component to update, and then click Change. The SQL Server 2005 Installation Wizard starts.
3.On the Component Selection page, select the SQL Server 2005 instance name to change. Click Next.
4.On the Feature Maintenance page, select a component to change from within the selected SQL Server 2005 instance. Click Next. The SQL Server 2005 System Configuration Checker starts.
On the Welcome page, click Next. The System Configuration Checker scans your computer's existing configuration.
5.After the System Configuration Checker finishes its scan, click Next.
6.On the Change or Remove Instance page, click Maintain the Virtual Server.
7.On the Cluster Node Configuration page, specify the nodes to include in the failover cluster instance. To add a node to the failover cluster, select the computer from the Available Nodes list and click Add. To remove a node from the failover cluster, select the computer from the Selected Nodes list and click Remove. Unavailable nodes are displayed in the Unavailable Nodes list, along with the reason for unavailability.
To create a one-node failover cluster, only the node that will be installed with the failover cluster should be listed in the Required Node list.
Click Next. For more information, see Cluster Node Configuration.
8.On the Ready to Update page, review the summary for your SQL Server installation. When you are satisfied with your choices, click Update.
9.On the Installation Progress page, you can monitor installation progress for individual cluster nodes by selecting a node from the Node list. Setup progress is displayed for the selected node. To view the log file for a component during installation, click the product or status name on the Installation Progress page.
10.On the Completing the Microsoft SQL Server Installation Wizard page, you can view the Setup summary log by clicking the link provided on this page. To exit the SQL Server Installation Wizard, click Finish.
Sean
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply