Is high availability part of how SQL Server Failover Clustering works? Or these two competing technologies?
From what I've read, it seems like HA is one of about three different ways you can "cluster" SQL Servers for failover. The other one would be "Database Mirroring". Dont know about the third one.
Please correct me If I'm wrong.
asked Dec 18 '09 at 04:45 PM in Default
High availability simply refers to the fact that the server system is in some way tolerant to failure.
That can be helped, in general, through hardware redundancy. For example, if a machine has redundant power supplies, then if one fails the machine will keep running. You can go a long way using hardware redundancy.
On top of that, you then have application redundancy, which usually refers to the ability for an application running on multiple hardware installations to respond to clients in a consistent manner from any of those hardware installations. That way, if the hardware does totally fail, or the O/S dies on a particular machine, another machine can carry on.
SQL Server caters for application redundancy in
Hope that clears it up a bit, but I'm sure some other people will have some good things to say too!
Matt covers it well. I would like to break out the replication solution into three different solutions.