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.
[Refer
Fig 3.7]
[Fig 3.7]
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]
[Fig 3.9]
[Fig 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()
[Fig 4.1]
Conclusion
This article has explained how to rebuild a failed node and
attach it back to the cluster.
»
See All Articles by Columnist MAK
» 
IE 7
Firefox 2.0
Comment and Contribute
