High Availabilty

• Thamizh

  Old Hand

  Points: 359

  More actions

  March 4, 2010 at 10:01 am

  #139122

  I'm confused about data high availability of the SQL server.Help me in this..

• Amit Singh

  Ten Centuries

  Points: 1295

  More actions

  March 4, 2010 at 11:24 am

  #1128660

  each option has its own pros and cons and has to be implemented based on evaluation of what are the needs of the architecture .... if you could post what are the needs then we all can help you decide which high availability you should use

  -------------------------------------------------
  -Amit
  Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]

• WayneS

  SSC Guru

  Points: 95460

  More actions

  March 4, 2010 at 11:29 am

  #1128668

  Other options to consider are:

  Log Shipping

  Clustering

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  March 4, 2010 at 11:50 am

  #1128679

  Wayne and Amit are correct. Wayne has some additional options for high-availability. There are even more options that can help with high-availability. You should give us what your needs/requirements are, then the community can better serve you.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events