Post reply

Loss of connection between Witness and Principle

  • November 21, 2012 at 1:59 am

    #285073

    Hi all

    i was checking our mirroing this morning and noticed in the Mirror monitor that our Mirror server could not connect to the Wtiness server.

    I tried restarting the end point, and also the SQL Service on the witness and Mirror but still got the problem. All the machines can ping each other. I also tried failing over the DBs to the Mirror which worked, however if I run a:

    select * from sys.database_mirroring_witnesses

    I can see no Principle_server_name and also its saying I am OUT_OF_SYNCH. Also the Mirror monitor still says no connection to the Witness for the Mirror server.

    Can anyone help?

    Many thanks

  • November 21, 2012 at 2:22 am

    #1561140

    Another point if I run

    select * from sys.dm_db_mirroring_connections

    I see 4 connections even though I have 5 databases mirrored, although perhaps one DB just isn't being accessed.

    If I run:

    select * from sys.database_mirroring

    The I can see all DBs are in a SYNCHRONIZEd state and running on the principle. Is it possible the Mirror Monitor is reporting incorrectly?

  • November 21, 2012 at 3:15 am

    #1561156

    OK the GUI for the Mirroring Monitor is reporting correctly now, I removed and re-created the mirror.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply