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

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

  • ASP.NET 1.1 garbage collection
    ... Web apps are dual proc servers (actually they are quad processor servers ... We have 5 web apps in a web farm using SQL Server session state. ... Our procs are consumed with garbage collection all day long. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Admin multiple servers with SuSE
    ... We have some SuSE servers running several web apps. ... "ik _heb_ niets tegen Microsoft, ...
    (alt.os.linux.suse)