Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
up vote 3 down vote accepted

You want to do database mirroring/log shipping : Here's an article by Paul Randal you might want to look at as well : That guy knows his stuff.

share|improve this answer

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

Your Answer


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.