Re: SQL 2005 Peer-To-Peer - How to configure failover (If possible

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Rubén,
It's what I thought but if anyone out there has figured a way of doing a
failover using Peer-to-Peer, let me know. Going to try to look into maybe
doing some type of polling against DB's to check status.
Thanks again...
Dave

"Rubén Garrigós" wrote:

Peer-to-peer is not doing that, it is only about replication of data. You
need to control the list of active nodes from your web application (and do
the fallback/load balance there) or you need to put some NLB or
DNS-roundrobin in front of your nodes to achieve that.

--
Rubén Garrigós
Solid Quality Mentors

"Dave A" <DaveA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:31A64F1B-CB1F-47A8-897F-6A82CBD4D2FF@xxxxxxxxxxxxxxxx
Hello All,
Was recently researching replication options for our SQL backend support
for
our web apps. I originally wanted to configure Peer-To-Peer replication
for
our DB's but for the life of me, could not find any articles on how to
configure (if it's even possible) failover for active applications.

I currently implemented Mirroring in which, when dealing with Web Apps
allowed a simple data connection string setting
"...Network=dbmssocn;server=Server01;Failover Partner=Server02;..." to
allow
for realtime failover.
I would like to implement Peer-To-Peer to allow for a more robust solution
and to delegate the loads across multiple SQL servers vs. 1 but is there a
similar delegation option that allows applications to know if Server1 is
not
responding, go to Server2 or Server3 or Server(n)?
Any feedback would be appreciated.
Thanks
Dave



.

Relevant Pages