What are the different SQL Server high availability options?
There’s quite a bit of overlap among HA technologies, but they’re typically meant to protect against different things. The good news: many of them work together quite well! Here are the more popular approaches, and what they’re primarily for.