Solved

Real-time, remote, redundancy

Posted on 2004-08-27
4
171 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
sql server query? 6 28
Copy Database Wizard Error 3 22
Sql query for filter 12 23
shrink datafile Sql server 4 17
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

747 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

12 Experts available now in Live!

Get 1:1 Help Now