Re: SQL 2005 Peer-To-Peer - How to configure failover (If possible)
- From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
- Date: Thu, 27 Mar 2008 22:23:44 -0000
Dave,
no doubt you already know this but just to clarify that in peer-to-peer the
data is partitioned, so going from one server to another for load balancing
only really refers to reads.
Anyway, there's no out-of-the box technique for swapping the connection and
establishing a heartbeat between the nodes, so it'll always be proprietrary.
Rgds,
Paul Ibison
(www.replicationanswers.com)
.
- Follow-Ups:
- Re: SQL 2005 Peer-To-Peer - How to configure failover (If possible)
- From: Rubén Garrigós
- Re: SQL 2005 Peer-To-Peer - How to configure failover (If possible
- From: Dave A
- Re: SQL 2005 Peer-To-Peer - How to configure failover (If possible)
- References:
- Prev by Date: SQL2000: Unable to insert into repliacted table
- Next by Date: Re: SQL 2005 Peer-To-Peer - How to configure failover (If possible
- Previous by thread: Re: SQL 2005 Peer-To-Peer - How to configure failover (If possible
- Next by thread: Re: SQL 2005 Peer-To-Peer - How to configure failover (If possible
- Index(es):
Relevant Pages
|