GilaMonster (8/21/2012)
If automatic failover's required then your only option (of the ones listed) is mirroring. Replication provides neither a failover mechanism nor a fail back. Logshipping the failover is manual.
Mirroring have two method, auto & manual failover.
automatic failover require one more system for configure witenss server, if choose auto failover, does this option any impact on performance in production server (principal server) ?