June 13, 2011 at 1:13 am
Hi there,
We have a failover cluster set up with a witness for automatic failover. We have failed over both automagically and manually on several occasions due to a series of issues but recently we have been experiencing automatic failovers for no obvious reason. I have done quite a bit of reading and searching and ran several queries to try to ascertain in depth logging with regards to the failover and keep drawing blanks or finding vague information that pretty much just sums up what we already know - That an automatic failover occurred.
Does anyone have a steer for me to go off and find some sort of verbose logging for an automatic failover, maybe even something that would directly pertain to the cause?
June 13, 2011 at 2:13 am
So you mirrored db from a clustered sqlserver instance ?
Did you check the mirroring events ?
(see attachments)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 13, 2011 at 3:07 am
Hi ALZDBA, thanks for your response.
I have taken a look at the mirroring state changes and I can follow the failover through its state changes. I was looking for a reason as to why the failover process was even started. I have trawled server event logs and SQL logs to no avail.
It also appears that the failover occurred as the connection to the Mirror was lost which I find very strange indeed. Why would the principal attempt to fail over when the mirror becomes unavailable?
I must be reading the state changes incorrectly. I'll do some more reading and get back to this post with a solution when/if I have one.
June 13, 2011 at 4:49 am
When using a witness, and configuring auto failover, your principal needs a quorum with the mirror OR with the witness. If none of both quorums can be established the principal db will be taken offline and put into recovery state !
That's why it needs to act whenever it looses connection to the mirror db.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply