We are in the process of installing a new ERP that is under SQL 2005.
I need to have high availability concerning that ERP and I was considering of having a mirror/failover/cluster/replica of my SQL Box on a remote off-site location.
But I need to be online with both Boxes , meaning that all Transactions are commited to SQL1 are then replicated to SQL2.
SQL2 will not be active unless SQL1 dies.
Which version of SQL does that ? and how it is done ?
How much bandwidth do I need ? a 512KB connection is enough ? or I need more ? How do I calculate how much I need ?