Elliott,

Thanks man for all your time.

I think i'm not explaining it right.

I'm trying to have an environment with 2 sql servers. traffic will go to sql1 all the time from both sites. If sql1 went down, sql2 will pick up automatically from site2. Also the databases between these 2 sql servers should be up-to-date so if one of the sql servers went down, the other sql server can function normally as if nothing happened.

based on the above requirements, i thought cluster will take care of the switching between the 2 sql servers if any of the servers goes down and peer-to-peer replication will take care of the replication of the databases.

am i little close? 🙂

thank you again.

Rami