Link to home
Start Free TrialLog in
Avatar of LarryDAH
LarryDAHFlag for United States of America

asked on

SQL mirror fails over often

I set up SQL mirroring with a witness server on Server 2008 R2 with SQL 2008. I can manually fail over fine from one to the other and everything syncs and works. However, for some reason the servers seem to fail over to the mirror a couple times a day. The principal is not being restarted and seems to be running fine. The principal is a VM, the mirror and witness are not if that matters. What can cause failover so often
Avatar of Ramesh Babu Vavilla
Ramesh Babu Vavilla
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LarryDAH


Where do you change the timeout?
Avatar of Ryan McCauley
Is there a network interruption that precedes the failover event? Can you set up a window that pings all the servers involved and then check it for odd network performance at the time of the next failover?

A failover is initiated if the witness loses contact with the principle but maintains contact with the mirror, so it's possible it could be VM-related (or more accurately, related to problems on the VM host server).
Network activity seems normal otherwise, no interruptions.
Changing the timeout can only be done thru SQL, that seems to be working.