troubleshooting Question

How to do that with SQL ?

Avatar of ammounpierre
ammounpierre asked on
DatabasesMicrosoft SQL Server 2005Microsoft SQL Server 2008
13 Comments3 Solutions290 ViewsLast Modified:
Hello Gurus,
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 ?
thanks gurus.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 13 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros