SQL Server Clustering from Command Line

Introduction

In this tutorial I will show you few command line options to manage a SQL Cluster status as well as for falling over.

Need of Command Line

The graphical tool works great, but what can you do when your Failover Cluster Manager freezes and you are not be able to start the program.

Here I will show you few command line that includes status checks and how to failover

How to view SQL Cluster

Run the following command to view all SQL Cluster on the network

view sql cluster
cluster list

View the Status of Notes

Run the following command to view the status of all nodes

view status of nodes
cluster node

View the status of cluster group

Run the following command to view the status of the cluster groups

view status of cluster group
cluster group

View the status of cluster Networks

Run the following command to view the status of cluster networks

view status of cluster networks
cluster network

How to view properties of all network interface devices

Run the following command to view the properties of all network interface devices

view properties of all network interface devices
cluster network interface

View the Status of Cluster Resources

Run the following command to view the status of Cluster Resources

view status of cluster resources
cluster resource

Failover Service to a new node

Run the following command to initiate a Failover

failover service to a new node
initiate failover

Conclusion

This article describes how to manage a SQL Cluster form the command line when graphical tool gets frozen. These command lines are easy to execute and give you all the information which you can get from graphical tool. You can also use these cluster command lines to configure, create, administer server cluster form form the command prompt.

Advertisements
This entry was posted in Clustering, Database Administration. Bookmark the permalink.

2 Responses to SQL Server Clustering from Command Line

  1. jacksonandrew771 says:

    Thanks Mustafa

    Like

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s