Windows Server2016 Powershell管理SQLServer AG
PS C:\Users\Administrator> Get-Cluster
Name
----
zedb-AlwaysOn
PS C:\Users\Administrator> Get-ClusterNode
Name ID State
---- -- -----
8202-zedb1 2 Up
8202-zedb2 1 Up
PS C:\Users\Administrator> Get-ClusterResource
Name State OwnerGroup ResourceType
---- ----- ---------- ------------
ZEDBAG Online ZEDBAG SQL Server Availability Group
ZEDBAG_10.72.11.37 Online ZEDBAG IP Address
ZEDBAG_ZEDB-SQL Online ZEDBAG Network Name
群集 IP 地址 Online 群集组 IP Address
群集名称 Online 群集组 Network Name
PS C:\Users\Administrator> Get-ClusterNetwork
Name State Metric Role
---- ----- ------ ----
群集网络 1 Up 70240 ClusterAndClient
参考文档:
https://docs.microsoft.com/en-us/powershell/module/failoverclusters/get-cluster?view=windowsserver2016-ps