Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a SQL Server that has important databases for our clients, if the server goes down we want another server to be ready to be switched over (we would just change the IP). The question is, how can we automatically sync the primary SQL Server to the secondary one periodically through out the day? Or even in real time?

Thanks!

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

You want to do database mirroring/log shipping : http://msdn.microsoft.com/en-us/library/ms187016.aspx. Here's an article by Paul Randal you might want to look at as well : http://msdn.microsoft.com/en-us/library/ee523927.aspx. That guy knows his stuff.

share|improve this answer
add comment

I am in the proccess of doing the same thing.

I am going with this method: Peer-to-Peer Transactional Replication MSSQL 2008

Here is the article for your version of MSSQL Peer-to-Peer Transactional Replication MSSQL 2005

share|improve this answer
    
Not real time, sorry ;) Plus has demands on the database ;) Mirroring is a better solution for two point - faster, less load AND - no change in the database necessary. –  TomTom Apr 15 '10 at 16:09
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.