1

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!

MetaGuru
  • 896
  • 6
  • 22
  • 36

2 Answers2

3

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.

Holocryptic
  • 5,665
  • 2
  • 29
  • 37
-1

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

Campo
  • 1,609
  • 17
  • 33
  • 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