Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Mirroring - Disconnected between Mirror and Witness Expand / Collapse
Author
Message
Posted Thursday, June 26, 2014 2:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 10:33 PM
Points: 5, Visits: 15
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?
Post #1586277
Posted Thursday, June 26, 2014 4:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 6,350, Visits: 13,674
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"
Post #1586345
Posted Thursday, June 26, 2014 7:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:06 AM
Points: 2,057, Visits: 1,427
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!
Post #1586402
Posted Thursday, June 26, 2014 9:19 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 820, Visits: 1,174
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.
Post #1586515
Posted Thursday, June 26, 2014 10:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 10:33 PM
Points: 5, Visits: 15
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.
Post #1586717
Posted Friday, June 27, 2014 4:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 820, Visits: 1,174
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.


Post #1586786
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse