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 ««12

Mirroring In sql server 2005- Witness Full Quorum Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 4:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 10:49 PM
Points: 2, Visits: 162
I had similar problem, where one instance shows "Connected" and other instance show "Disconnected" in Database Mirroring Monitor. I have resolved the problem by "Remove Mirroring" and then configuring the same setup again. Hope this may help somebody.
Post #1386282
Posted Thursday, June 26, 2014 2:00 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,

Old thread but I have got a similar problem. Edit: Sorry for posting in SQL Server 2005. I will post in correct forum.

I have 2 databases mirrored. They both uses same Primary, same Mirror and same Witness. All servers are SQL Server 2008. The first DB 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 #1586269
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse