Issue sp_companion without any options to display the mode the companion is currently in. For example:
sp_companion
Server 'MONEY1' is alive and cluster configured. Server 'MONEY1' is configured for HA services. Server 'MONEY1' is currently in ‘Symmetric normal’ mode.
MONEY1 is configured for symmetric failover and is running in normal companion mode.You can also use the @@cmpstate global variable to determine the mode. At the isql prompt, enter:
select @@cmpstate
The @@cmpstate global
variable is not used in an non-high availabilty environment, and
reports a value of -2.
@@cmpstate |
Companion mode |
---|---|
0 |
Single server |
1 |
Reserved |
2 |
Secondary normal |
3 |
Secondary suspended |
4 |
Secondary failover |
5 |
Secondary failback |
6 |
Reserved |
7 |
Primary normal |
8 |
Primary suspended |
9 |
Primary failback |
10 |
Reserved |
11 |
Symmetric normal |
12 |
Symmetric failover |
13 |
Symmetric suspended |
14 |
Symmetric failback |
15 |
Reserved |