Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Feb 2, 2005

Rebuilding SQL Server Cluster Nodes - Page 4

By Muthusamy Anantha Kumar aka The MAK

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



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date