homepage Welcome to WebmasterWorld Guest from 54.227.171.163
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
Forum Library, Charter, Moderator: open

Webmaster Hardware Forum

    
Sql server replication advice
Sql server replication advice
piffdude

10+ Year Member



 
Msg#: 261 posted 3:41 pm on Jul 20, 2005 (gmt 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!

 

lovethecoast

10+ Year Member



 
Msg#: 261 posted 4:56 pm on Jul 20, 2005 (gmt 0)

Will the publish/subscribe system of SQL Server not suffice?

piffdude

10+ Year Member



 
Msg#: 261 posted 7:52 am on Jul 22, 2005 (gmt 0)

Does the sql server replication provide the ability to failover (either manually or auto) if the main server dies?

lovethecoast

10+ Year Member



 
Msg#: 261 posted 9:38 am on Jul 22, 2005 (gmt 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.

piffdude

10+ Year Member



 
Msg#: 261 posted 12:00 pm on Jul 22, 2005 (gmt 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?

aspdaddy

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 261 posted 5:09 pm on Jul 26, 2005 (gmt 0)

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved