Welcome to WebmasterWorld Guest from 54.167.194.59

Forum Moderators: open

Message Too Old, No Replies

Sql server replication advice

Sql server replication advice

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

New User

10+ Year Member

joined:Feb 16, 2004
posts:11
votes: 0


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 July 20, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:July 19, 2004
posts:178
votes: 0


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

New User

10+ Year Member

joined:Feb 16, 2004
posts:11
votes: 0


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

Junior Member

10+ Year Member

joined:July 19, 2004
posts:178
votes: 0


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 July 22, 2005 (gmt 0)

New User

10+ Year Member

joined:Feb 16, 2004
posts:11
votes: 0


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 July 26, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


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