Solved

Real-time, remote, redundancy

Posted on 2004-08-27
4
173 Views
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.
0
Comment
Question by:cwest1
  • 3
4 Comments
 
LVL 34

Expert Comment

by:arbert
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:

http://www.microsoft.com/windowsserver2003/technologies/clustering/default.mspx

Brett
0
 
LVL 34

Expert Comment

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

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_4ctw.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;260758


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

Author Comment

by:cwest1
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?
0
 
LVL 34

Accepted Solution

by:
arbert earned 125 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:

http://www.sql-server-performance.com/sql_server_log_shipping.asp


Brett
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

813 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now