Data Replication

[joeblough]

I need to set up Data Replication to another MS SQL server, I am thinking about a real-time service solution. We have a database accessable via Cold Fusion/custom HTML program and would like to have ALL data safe- perhaps a fail over system that the user would not know that the main system is down. I am looking at Double Take, Live Vault, ArcServe, and Veritas for solutions. anyone set this up with success/failure?

Would the inherant SQL replication feature do it alright- would Enterprise ver. and/or SQL 2000 be a viable route?

Any and all advice is appreciated!

Blake Net Admin. MCSE
DBlakeAdams@yahoo.com

 

[TomSark]

A no-latency replication solution can be implemented if desired, but it's best to have a well-connected, fast network connection between the two servers. You can have replication involved with continuous synchronization. SQL Server 7.0 and 2000 both allow this.

This will NOT guarantee seemless failover, however. If I am reading your question correctly, you should rather look into clustering as opposed to replication to solve this problem.

Both 7.0 and 2000 support clustering, but Windows 2000 Enterprise and SQL 2000 are easier to set up and implement clustering. Tom Davis
tdavis@sark.com

http://www.sarkdallas.com