ms cluster cli

 

 


C:\>cluster  /version

Cluster Name:     sqlc
Cluster Version:  6.1 (Build 7601: Service Pack 1)
Cluster Vendor:   Microsoft(R) Cluster service

C:\>cluster  /list

Cluster Name
---------------
SQLC
SQLC

C:\>cluster  /cluster:SQLC /listnetpri

Listing the priority order of internal networks:

   Network Name
   ---------------
 1 lan
 2 heartbeat

# Add node

cluster ClusterName  /addnodes:NodeName1
 
cluster group

C:\>cluster group

Listing status for all available resource groups:

Group                Node            Status
-------------------- --------------- ------
Cluster Group        WINSRV02        Online
Available Storage    WINSRV02        Offline
SQL Server (MSSQLCLUSTER) WINSRV02        Failed

可用指令

/moveto

* Quorum Disk 是在 "Cluster Group" 的

cluster group "Cluster Group" /moveto:winsrc01

/LISTOWNERS

/ON

/OFF

P.S.

Available Storage always shows offline

原因: "Available Storage" is empty. In other words there are no unused cluster disk.

 


cluster node

C:\>cluster node

Listing status for all available nodes:

Node           Node ID Status
-------------- ------- ---------------------
WINSRV01             1 Up
WINSRV02             2 Up

 


cluster net

C:\>cluster net

Listing status for all available networks:

Network                                  Status
---------------------------------------- -----------
lan                                      Up
heartbeat                                Up

cluster netint

C:\>cluster netint

Listing status for all available network interfaces:

Node                       Network                    Status
-------------------------- -------------------------- -------
WINSRV02                   heartbeat                  Up
WINSRV01                   lan                        Up
WINSRV02                   lan                        Up
WINSRV01                   heartbeat                  Up

 


cluster res

C:\>cluster res

Listing status for all available resources:

Resource             Group                                Node            Status
-------------------- --------------------                 --------------- ------
Cluster IP Address   Cluster Group                        WINSRV02        Online
Cluster Name         Cluster Group                        WINSRV02        Online
SharedDisk           Cluster Group                        WINSRV02        Online
SQL IP Address 1 (MSSQLCLUSTER) SQL Server (MSSQLCLUSTER) WINSRV02        Online

SQL Network Name (MSSQLCLUSTER) SQL Server (MSSQLCLUSTER) WINSRV02        Online

SQL Server (MSSQLCLUSTER) SQL Server (MSSQLCLUSTER)       WINSRV02        Failed
SQL Server Agent (MSSQLCLUSTER) SQL Server (MSSQLCLUSTER) WINSRV02        Offline
SQL_DATA             SQL Server (MSSQLCLUSTER)            WINSRV02        Online

 


 

 

 

Creative Commons license icon Creative Commons license icon