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

Mirror Monitoring issue Expand / Collapse
Author
Message
Posted Friday, October 19, 2012 8:12 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:29 AM
Points: 453, Visits: 578
I have setup mirroring on a pair of SQL 2008 R2 servers. This appears to be working ok when I run the monitoring software on the partner I can see both the principal and mirror instance. the state on both says Synchronised. If I try to run it on the Principal server it gives the miiror the wrong sql instance name and cant connect to it.
Lookng at the sys.database_mirroring table the mirroring_partner_name fiels is correctly named but the mirroring_partner_instance has the wrong name. I have tried deleting the server instance connections and re adding them but it just keeps putting the wrong instance name in. As it cant connect it throws an eror and fails to connect.
two questions spring to mind
1) Is mirroring working ? as the mirror monitor claims
2) How can I update the sys table to put the right instance name in to the monitor
Post #1374847
Posted Friday, October 19, 2012 1:13 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:56 PM
Points: 6,365, Visits: 13,695
can you post the results of the following query please

select	d.name
, dm.mirroring_state_desc
, dm.mirroring_role_desc
, dm.mirroring_safety_level_desc
, dm.mirroring_partner_instance
, dm.mirroring_witness_name
, dm.mirroring_state_desc
, dm.mirroring_redo_queue
, dm.mirroring_redo_queue_type
from sys.databases d inner join sys.database_mirroring dm
on d.database_id = dm.database_id
where d.name = 'yourdb'



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

"Ya can't make an omelette without breaking just a few eggs"
Post #1375012
Posted Monday, October 22, 2012 2:50 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:29 AM
Points: 453, Visits: 578
attached csv dump of query results as txt file

The mirroring partner instance field contains the mis-spelt server name


  Post Attachments 
output_text.txt (19 views, 284 bytes)
Post #1375308
Posted Thursday, November 1, 2012 5:42 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:29 AM
Points: 453, Visits: 578
Mirroring is now suspended and I can't resume it as it attempts to reconnect to the database server that doesnt exist. I can remove mirroring and re-create it. but although I put in the correct database server name it still uses the original incorrect entry
Post #1379754
Posted Thursday, September 11, 2014 11:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:49 PM
Points: 1, Visits: 2
Hi I was wondering if you ever found out the solution to your issue. I have a very similar issue where I need to change the mirroring_partner_instance.
Post #1612765
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse