Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Mirroring - Disconnected between Mirror and Witness


Database Mirroring - Disconnected between Mirror and Witness

Author
Message
tommi_j
tommi_j
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
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?
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8777 Visits: 16548
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" ;-)
Lempster
Lempster
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2683 Visits: 1657
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! ;-)
Neeraj Dwivedi
Neeraj Dwivedi
SSC Eights!
SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)

Group: General Forum Members
Points: 887 Visits: 1319
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.
tommi_j
tommi_j
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
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.
Neeraj Dwivedi
Neeraj Dwivedi
SSC Eights!
SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)

Group: General Forum Members
Points: 887 Visits: 1319
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search