|
In a functioning V12 HA setup, the following queries consistently show MirrorServerState as NULL: -- On primary...
SELECT DB_PROPERTY ( 'MirrorRole' ) AS a,
DB_PROPERTY ( 'MirrorServerState' ) AS b,
DB_EXTENDED_PROPERTY ( 'MirrorServerState' ) AS c,
DB_PROPERTY ( 'MirrorServerWaits' ) AS d,
DB_PROPERTY ( 'MirrorState' ) AS e;
a,b,c,d,e
'primary',,,'0','synchronized'
-- On secondary (mirror)...
SELECT DB_PROPERTY ( 'MirrorRole' ) AS a,
DB_PROPERTY ( 'MirrorServerState' ) AS b,
DB_EXTENDED_PROPERTY ( 'MirrorServerState' ) AS c,
DB_PROPERTY ( 'MirrorServerWaits' ) AS d,
DB_PROPERTY ( 'MirrorState' ) AS e;
a,b,c,d,e
'mirror',,,'0','synchronized'
|
|
The second parameter to See the docs on db_extended_property (Note: bit.ly redirect to dcx.sybase.com) |
