• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

Real-time, remote, redundancy

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
cwest1
Asked:
cwest1
  • 3
1 Solution
 
arbertCommented:
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
 
arbertCommented:
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
 
cwest1Author Commented:
(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
 
arbertCommented:
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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now