{"id":185,"date":"2012-06-21T19:38:17","date_gmt":"2012-06-21T19:38:17","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=185"},"modified":"2014-03-05T19:49:31","modified_gmt":"2014-03-05T19:49:31","slug":"sql-server-clustering-management-inside-the-command-line","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/sql-server-clustering-management-inside-the-command-line\/","title":{"rendered":"SQL Server Clustering Management inside the command line"},"content":{"rendered":"

There are numerous commands you can run to manage a SQL Cluster from the command line. Below I’ll show you a few of these that include status checks and how to failover.<\/p>\n

How to View SQL Clusters <\/strong><\/h3>\n

This can be run from your workstation to view all SQL Clusters on the network you are connected to.<\/p>\n

\n
cluster \/list<\/pre>\n<\/div>\n
\"SQL<\/a><\/p>\n
View Status of Nodes<\/h3>\n
You can run this to view the status of all nodes in the cluster.<\/p>\n
\n
cluster node \r\n--or \r\ncluster node \/status<\/pre>\n<\/div>\n
\"SQL<\/a><\/p>\n
View Status of Cluster Groups<\/h3>\n
You can run this to view the status for all cluster resource groups.<\/p>\n
\n
cluster group \r\n--or \r\ncluster group \/status<\/pre>\n<\/div>\n
\"SQL<\/a><\/p>\n
View Status of Cluster Networks<\/h3>\n
You can run this to view the cluster networks status.<\/p>\n
\n
cluster network \r\n--or \r\ncluster network \/status<\/pre>\n<\/div>\n
\"SQL<\/a>
\nClick here to view the rest of this post.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
There are numerous commands you can run to manage a SQL Cluster from the command line. Below I’ll show you a few of these that include status checks and how to failover. How to View SQL Clusters This can be run from your workstation to view all SQL Clusters on the network you are connected […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,100],"tags":[102,43,7],"class_list":["post-185","post","type-post","status-publish","format-standard","hentry","category-clustering","category-high-availability","tag-clustering","tag-command-prompt","tag-high-availability"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=185"}],"version-history":[{"count":1,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/185\/revisions"}],"predecessor-version":[{"id":190,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/185\/revisions\/190"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}