Welcome to WebmasterWorld Guest from 54.161.149.107

Forum Moderators: open

Sql server replication advice

Sql server replication advice

   
3:41 pm on Jul 20, 2005 (gmt 0)

10+ Year Member



I currently have a Sql server that does daily backups and these are saved off site. However I'm getting to the stage where I need realtime backup, I have the hardware and link for a redundant sql server to be sat in another location. I just need to find the software to provide the live replication. I don't really want to get clustered servers as this would cost too much.

I have been looking at some software called Double take by NSI. I have seen a live demonstration of it and it appears to do what I need. But my boss has asked the question is there anything cheaper? I've started to look at Veritas Replication Exec but am finding very limited information on its support for sql server and its features.

Any advice would be greatly appreciated!

4:56 pm on Jul 20, 2005 (gmt 0)

10+ Year Member



Will the publish/subscribe system of SQL Server not suffice?
7:52 am on Jul 22, 2005 (gmt 0)

10+ Year Member



Does the sql server replication provide the ability to failover (either manually or auto) if the main server dies?
9:38 am on Jul 22, 2005 (gmt 0)

10+ Year Member



If you're using the Enterprise version, you can have an Active/Passive server cluster that will failover in the event of a failure on your "Active" server.

This has saved us a ton of times. Technically, our main DB "server" (which is actually a cluster) hasn't been down in over three years.

12:00 pm on Jul 22, 2005 (gmt 0)

10+ Year Member



I wasn't really wanting to get a cluster setup as it will cost a furtune. I have seen that 'double take' does failover and keeps a live replication, does anyone have any experience of this or maybe Veritas Replication Exec?
5:09 pm on Jul 26, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



The new mirror feature coming in SQL2005 might be just the thing for this.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month