Mirroring problem

Mirroring problem

Post by JHD » Fri, 13 Apr 2007 04:04:24


hi,

I've setup database mirroring in high safety mode with automatic failover
(with a witness) and the databases seem to be synchronising ok (I've failed
over a few times to test and all seems well). The only problem I have
however is that when I open up the Database Mirroring Monitor on one of the
servers I see that the witness connection is in the disconnected state for
one of the servers even though they are both online as far as I can see. Has
anyone else come across this?

thanks, jack.
 
 
 

Mirroring problem

Post by Hilary Cot » Fri, 13 Apr 2007 10:13:14

It sounds like the witness is not connected to either partner. Can you issue
this query for me?

select mirroring_witness_state, mirroring_witness_state_desc from
sys.database_mirroring

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/