High Availabilty

Question

High Availabilty

Thamizh

Old Hand

Points: 309
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..

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Amit Singh Ten Centuries Points: 1295 More actions · Answer 1

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: 95405 More actions · Answer 2

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: 281324 More actions · Answer 3

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