SQL Mirroring Witness RRS feed

  • Question

  • I have managed to set up mirroring on SQl 2005 however i have a come across a problem that i dont know how to resolve.

    Im running the mirroring  with 'High Safety with automatic failover.'

    If i instagate a failover on the  Principal Database, the mirror becomes the Principal, and vice versa ...  great .. how ever ..  i tried the golden test by making the principal server dissapear by yanking out the network connection, expecting the mirror to become the principal.....nope  it just stays there in a disconnected / restoring state which isnt any good to man nor beast .  I thought that the Witness should have dectected that the principal database had 'dissapeared' and would have made the mirror the Principal. 

    Any pointers on where i might have gone wrong in the setting up process,  i used the mirror wizard

    Thursday, September 14, 2006 2:59 PM

All replies

  • Everything you list seems correct, however ensure that the Principal and Mirror are in the synchronized state when you pull the network cable. Also you must ensure that the Witness and the Principal can communicate so that they can agree that the Principal is unreachable. If the network connection between them is not available, they can't agree to failover.




    Monday, September 18, 2006 3:32 PM
  • Matt,


    Sorry for the dealy in getting back to you, i managed to sneek a couple of weeks ooff whilst the boss had his back turned.  I have looked at all the network connections and carnt for the life see where the problem lies.  all three servers fire up under tor domain administrators account  ( till i can iron out the security ) , each of the servers can see and access each other through the network.. 


    is there any tests i can do that can help track the problem..?


    thanks again for you help



    Wednesday, September 27, 2006 1:58 PM