SQL2005 and Mirroring

Posted on 2011-05-09
Medium Priority
Last Modified: 2012-05-11
If you have a mirrored db and the mirror set was split, I could presume the the sql native client would not failover to the partner database in this situation ?
Question by:rimmena
LVL 28

Accepted Solution

Ryan McCauley earned 1000 total points
ID: 35724865
I'm not sure exactly what you're asking - can you clarify the situation you're wondering about?

Mirroring actually involves 3 servers - a primary, a mirror, and a witness. The primary and mirror will communicate with each other to determine who is in charge (the primary), and the witness exists to settle any disputes, and is in charge of promoting the mirror if the primary database goes offline.

If you have SQL Server Mirroring set up and your main server drops off, then clients set up properly (with the "mirroring" property in the connection string set) will fail over to the mirror as they should. They won't fail back until you do it manually - in the case of a mirror failover, the mirror actually becomes the new primary, and the old primary becomes the new mirror, so that you'll need another failure (of the new primary server) to cause a failover to happen.

If that doesn't answer your question, please provide some more detail about the situation you're asking about.
LVL 15

Expert Comment

by:Faiga Diegel
ID: 35724894

"and the mirror set was split" -- you mean you removed the mirrored DB from the primary DB? If yes, then yes it will not fail over.  

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

In this article, we’ll look at how to deploy ProxySQL.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

862 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