Microsoft® SQL Server High Availability

Summary

There are perhaps thousands of considerations that must be dealt with when building a viable production implementation, let alone one that needs to be highly available. You would be well advised to make the extra effort of first properly determining which highly available solution matches your application's needs, then to switch focus to what is the most effective way to implement that chosen high availability solution. There are critical design decisions that need to be addressed for each high availability solution. If, for example, you choose data replication to support your HA needs, you must determine the right type of replication model to use (like a central publisher and remote distributor), what the schema limitations might be, ...