Working with Cluster Group in Windows Server 2008

Your rating: None Average: 5 (2 votes)

Windows 2008 failover cluster administrator is difficult to figure out. To failover to another node, you can use the UI or use the command line. The UI is easy as you can see in this image:

Failover Cluster Management Tool


However, you can move the Cluster Group by using command line as follows

cluster group "cluster group" /move:sgjssdlvmrd057

Next, to get the cluster configuration of the quorum

cluster SGJSRDCL001 /quorum:"Cluster Disk 1"

Witness Resource Name Path Type

--------------------- --------------------------------------------- --------

Cluster Disk 1 Q:\Cluster\ Majority


and this would help to get to know the status:


Finally, to change the startup parameter on a SQL Cluster during instance when your SQL Server resource is OFFLINE:

cluster res "SQL Server" /removecheck: "Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLSERVER"

Do the necessary changes from the SQL Configuration Manager

cluster res "SQL Server" /addcheck: "Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLSERVER"


Bring the SQL Server Resource online