Real-time, remote, redundancy

Posted on 2004-08-27
Medium Priority
Last Modified: 2006-11-17
I wasn’t sure what the subject should really be so I just used some keywords. I’ve not the following before so I thought I’d ask for some terse steps which I can research. Point me in the right direction and I’ll find my way :)
I want to copy some dbs to a backup server. If server 1 fails—power supply dies for example—server 2 will immediately take over. What are considered the best practices to sync db files in real-time from server 1 to server 2? Thankyou.
Question by:cwest1
  • 3
LVL 34

Expert Comment

ID: 11916107
If you need realtime, you're almost for sure going to have to look at a clustering solution.  You could also use logfile backups or transactional replication, but you do run into the problem of a possible lag time and lost transactions.

Here is a start:


LVL 34

Expert Comment

ID: 11916168
Here are some additional articles specific to SQL Server:


I would highly recommend clustering with Windows 2003 (if you decide to cluster).  The clustering support in 2003 is awesome...

Author Comment

ID: 11935725
(Unfortunately) I don’t have SQL Server Enterprise, which I’ve discovered is required to implement a real-time backup plan. Guess I’ll have to resort to quite frequent backups to Server 2. I intend to backup the complete files and not incrementally—the databases are 2-5 gigs. Does it seem sensible, or this a better way of going about it, to restore the complete files to SQL Server on Server 2 if Server 1 fails?
LVL 34

Accepted Solution

arbert earned 500 total points
ID: 11937087
NO, Enterprise is NOT required......You have several other options--Log Shipping, or transactional replication.  Personally, I would recommend logshipping--this is my favorite link to setting it up:



Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question