Database mirroring monitor mirroring state

david_32
david_32 used Ask the Experts™
on
Hi Folks,

I have SQL 2005 mirroring happening

the mirroring state + current role of my databases in database mirroring monitor for the mirror says not connected, the principal says synchronized. I actually failed over a database to check if it has recent data transferred  and it seems it does. To setup mirroring I needed to so this via T-SQL rather than the mirroring wizard as the wizard could not see the partner I was connecting to. On the mirror in db mirror monitor it is also saying not connected. The partner are on different networks through a firewall - which seems to not be the problem because the failover seems to be ok. What is going on?

 
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
The principal says synchronized, but the mirror says disconnected? Doesn't seem right.

Do you have multiple SQL instances on the mirror server?

Rob

Author

Commented:
no I don't

Commented:
The two servers must be talking a bit, because the principal thinks they're synchronized. But it definitely seems strange that the mirror doesn't think so.

If you turn the mirror off (stop the service perhaps), does the principal realise and change its status?

Rob
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
yes - disconnected
Commented:
Ok. In that case it seems that there's just an issue with the monitoring system, seeming to be unable to query both boxes at once. The actual mirroring seems to be working, which is good - but I do agree it's somewhat unnerving.

I wonder if there are firewall issues - can you see if anything's being blocked?

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial