Database Mirroring - Disconnected between Mirror and Witness

  • Hi Everyone,

    I have 2 databases mirrored. They both uses same Primary, same Mirror and same Witness. All servers are SQL Server 2008. The first DB is OK and shows fully connected and synchronized in Database Mirroring Monitor but the second DB shows disconnected between Mirror and Witness. A restart of the Witness does not help. A manual failover back and forth of the second DB does not help either.

    When I checked sys.database_mirroring_witness in Witness server, I discovered that regarding the second DB, the Mirror server name (TCP://srv.mycompany.com:5022) is missing from mirror_server_name column. Is there a way to fix this?

    I guess removing the mirroring and then configuring the same setup again could work but this is a critical DB and not easily done. Is there another way to fix this issue without removing and re-creating mirroring?

  • tommi_j (6/26/2014)


    I guess removing the mirroring and then configuring the same setup again could work but this is a critical DB and not easily done.

    What's so difficult about it?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry Whittle (6/26/2014)


    tommi_j (6/26/2014)


    I guess removing the mirroring and then configuring the same setup again could work but this is a critical DB and not easily done.

    What's so difficult about it?

    +1. Particularly if you had the foresight to script the mirroring setup! 😉

  • Let me ask you a question. What is the state of the second database? If I understood you correctly, then it is that your mirror is not connected to witness. What about the Primary?

    The simplest way to check is that is with "Database Mirroring Monitor".

    If your Primary database state is Synchronized and connected to witness, you can fail over to Mirror --> Configure Security and set the Witness Server and -->Fail back to primary.

  • The state of both databases are synchronized. Everything is working but in "Database Mirroring Monitor" the second database has lost connection only between between Mirror and Witness. Everything else shows as Connected. It's not affecting anything right now but i want to correct this before it does.

  • So that is a good news.

    Follow the steps as suggested earlier ..

    you can fail over to Mirror --> Configure Security and set the Witness Server and -->Fail back to primary.

    It ill solve the issue.

Viewing 6 posts - 1 through 5 (of 5 total)

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