June 21, 2012 at 3:34 am
Hi Guys,
May be it is very basic question for you. But I am totally confused with these 2.
1) What is the difference between Scalability and High availability in SQL Server?
2) What are the different options available for each in SQL Server?
_____________________________________________
One ounce of practice is more important than tonnes of dreams
June 21, 2012 at 3:59 am
Scalability: Solutions used for adapting to higher load.
Availability: Solutions used to reduce downtime.
Scalability: More hardware, Replication, Always On (SQL Server 2012), Service Broker, to some content Database Mirroring.
Availability: Clustering, Database Mirroring, Log Shipping, Backup/Restore, Service Broker, Replication, Always ON (SQL Server 2012)
June 21, 2012 at 4:04 am
okbangas (6/21/2012)
Scalability: Solutions used for adapting to higher load.Availability: Solutions used to reduce downtime.
Scalability: More hardware, Replication, Always On (SQL Server 2012), Service Broker, to some content Database Mirroring.
Availability: Clustering, Database Mirroring, Log Shipping, Backup/Restore, Service Broker, Replication, Always ON (SQL Server 2012)
Hi Ole,
Thanks TON !!!
I have almost freezed my head by reading different articles and could not reach any conclusion. This is the answer I was looking for. Thanks again.
_____________________________________________
One ounce of practice is more important than tonnes of dreams
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply