homepage Welcome to WebmasterWorld Guest from 54.204.59.230
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
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




msg:1567840
 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




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

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

piffdude




msg:1567842
 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




msg:1567843
 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




msg:1567844
 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




msg:1567845
 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