Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have two clusters each with two nodes configured in active/passive; the two clusters take part in a high-availability mirroring session using a separate server as the witness.

When a node fails in the primary cluster, the mirroring failover seems to kick in before the secondary node of the primary cluster has had time to come online.

Is there anyway of telling the witness server to let the passive node attempt to come online before initiating the failover to the secondary cluster?

share|improve this question
add comment

1 Answer 1

up vote 7 down vote accepted

Database mirroring questions from TechEd: failovers and partner timeouts

... when the cluster is failing over and the principal instance is unavailable for 60-90 seconds, the other instances in the mirroring session will time-out after ten seconds and initiate a mirroring failover... The solution to the problem is to change the partner time-out value - a facility that isn't well known. To change the partner time-out value for a mirroring session, use the following code:

ALTER DATABASE mydatabase SET PARTNER TIMEOUT 90;
share|improve this answer
    
Thank you that was exactly what I was after - a very interesting article too! Much appreciated. –  Mr.Brownstone Aug 24 '12 at 21:05
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.