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) |