Step 9 - Install the latest Service pack for SQL Server.
Download the service pack from the Microsoft website.
Extract the file and run the setup.bat.
Type the SQLServer Virtual server name. [Refer Fig 3.8]
Step 10 - Move the "SQL Group"
Step 10 - Move the "SQL Group" from the node "SQLNode2"
to "SQLNode1" and vice versa and make sure it fails over properly.
[Refer Fig 3.9 and 4.0]
Login to SQL Server and run the following commands to make
sure SQL Server cluster is working properly. [Refer Fig 4.1]
xp_cmdshell 'Ping -a 127.0.0.1' to see which node is active.
select * from ::fn_servershareddrives()
select * from ::fn_virtualservernodes()
This article has explained how to rebuild a failed node and
attach it back to the cluster.
See All Articles by Columnist MAK