question

pits avatar image
pits asked

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
failover partner
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
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
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

+1 Definitely follow the link and read up.
0 Likes 0 ·
Blackhawk-17 avatar image
Blackhawk-17 answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.