Solved

SQL mirror fails over often

Posted on 2013-01-08
5
331 Views
Last Modified: 2013-01-30
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
Comment
Question by:LarryDAH
  • 3
5 Comments
 
LVL 10

Accepted Solution

by:
sqlservr earned 500 total points
ID: 38757728
increase the time out and check the peformance of the
0
 

Author Comment

by:LarryDAH
ID: 38758887
Where do you change the timeout?
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 38768874
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
 

Author Comment

by:LarryDAH
ID: 38819078
Network activity seems normal otherwise, no interruptions.
0
 

Author Closing Comment

by:LarryDAH
ID: 38836844
Changing the timeout can only be done thru SQL, that seems to be working.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question