Failover Partner

In mirroring whta is role of failover partner?

Where it is exactly placed? is it placed between Users and Primary/mirror server?

Is failover partner receives signal of failover from witness server and divert users according to witness server signal?

or failover partner work independently and directly with primery/mirror server without any signal from witness server? rgds
more ▼

asked May 09 '12 at 12:19 PM in Default

pits gravatar image

830 73 91 92

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
I'd recommend reading up articles such as http://msdn.microsoft.com/en-us/library/ms189852.aspx (and those mentioned in the Resources section at the bottom of the article) and then if you try implementing Mirroring on your test server(s) and hit a problem then feel free to come back with a specific question
more ▼

answered May 09 '12 at 01:02 PM

Fatherjack gravatar image

Fatherjack ♦♦
41.2k 72 77 107

+1 Definitely follow the link and read up.
May 09 '12 at 01:25 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

The TL;DR answer is that a failover partner - the Mirror, is the server receiving the transactions from the Primary database. If both the Mirror and the Witness server lose contact with the Primary but still can communicate with each other (form a quorum) a failover will be initiated. If the Mirror cannot "*see*" the Witness and the Primary it will not failover as it can't be sure of the need to do so.

Users are not auto-directed to the mirror unless a load balancing mechanism is in place or the connect strings in the applications have a failover setting. The mirroring technology in SQL Server itself does not participate in that.
more ▼

answered May 09 '12 at 01:25 PM

Blackhawk-17 gravatar image

11.8k 28 30 35

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 09 '12 at 12:19 PM

Seen: 444 times

Last Updated: May 09 '12 at 01:25 PM