• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

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
0
LarryDAH
Asked:
LarryDAH
  • 3
1 Solution
 
Ramesh Babu VavillaCommented:
increase the time out and check the peformance of the
0
 
LarryDAHAuthor Commented:
Where do you change the timeout?
0
 
Ryan McCauleyData and Analytics ManagerCommented:
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).
0
 
LarryDAHAuthor Commented:
Network activity seems normal otherwise, no interruptions.
0
 
LarryDAHAuthor Commented:
Changing the timeout can only be done thru SQL, that seems to be working.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now