SQLWebpedia

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:

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:

CLUSTER RESOURCE /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

Thanks,

Ganesh