Solved

Real-time, remote, redundancy

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

730 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