Solved

SQL mirror fails over often

Posted on 2013-01-08
5
323 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
sql Audit table 3 48
query help 18 51
Selection from table2 where criteria for table1 10 23
Extract XML Data from using TSQL 5 31
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now