Clustering or Replication

• parth83.rawal

  SSCommitted

  Points: 1858

  More actions

  May 4, 2009 at 4:20 am

  #130528

  Lets say i have a Server on locations......Us and Canada

  Where i have a SQL Server, now to ensure almost 100% availability what is the Best Approach.

  I know as ,

  Offline processing. (in Replication)

  You may wish to manipulate data from your database on a machine that is not always connected to the network.

  but i know very little about Clustering but as much as i know it is for reducing the down time in the SQL Server.

  So what is the Best approach for it!!

  Thanks

  Parth

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  May 4, 2009 at 4:40 am

  #988023

  Check out

  http://www.sql-server-performance.com/faq/cluster_log_shipping_replication_p1.aspx

  Tanx 😀