Solved

SQL mirror fails over often

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
CONVERT date time to a different time zone. 2 42
affinity mask in sql server 1 22
Restrict result set 1 33
AWE-based memory on 32-bit servers 1 23
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

932 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

11 Experts available now in Live!

Get 1:1 Help Now