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'

asked 21 Aug '10, 15:42

Breck%20Carter's gravatar image

Breck Carter
27.4k424585836
accept rate: 21%

edited 22 Aug '10, 22:34

Calvin%20Allen's gravatar image

Calvin Allen
1.5k232638


The second parameter to db_extended_property should be the name of a server, and the property value will indicate the state of that server.

See the docs on db_extended_property (Note: bit.ly redirect to dcx.sybase.com)

permanent link

answered 22 Aug '10, 01:02

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371109
accept rate: 52%

Comment Text Removed
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×409
×51

question asked: 21 Aug '10, 15:42

question was seen: 704 times

last updated: 22 Aug '10, 22:34