up vote 1 down vote favorite
share [g+] share [fb]

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!

link|improve this question
74% accept rate
feedback

2 Answers

up vote 3 down vote

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.

link|improve this answer
feedback
up vote -1 down vote

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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