An Overview of SQL Server High Availability Options

There’s no doubt that availability is one of the most important if not the most important job for the database administrator. However, choosing the right options isn’t always easy because there’s a lot of different options and each is designed for a different purpose. Here's an quick overview of SQL Server’s different high availability options: Windows Failover Clustering—Microsoft's premier high availability solution, Windows Failover Clustering ...

Buy This Project Plan Now!

This content is part of the Migrating to SQL Server 2008 & 2008 R2 Project Plan.

Purchase this project plan to receive:

  • Step-by-step guidance for managing your project, start to finish
  • Tested advice for preparing for and completing your project
  • Insights to help you avoid common pitfalls and traps

Already purchased this? to view your content.

Discuss this Blog Entry 2

msaroyan
on Aug 3, 2011
There are 3 operating modes of mirroring. High safety with automatic failover which requires a witness server High safety without automatic failover, which does not require a witness server High Performance mode. High Performance mode is the one that requires the Enterprise edition of SQL Server, not the High Safety mode. Best. M.S
razmus
on Aug 4, 2011
It would seem that Microsoft considers Replication as a MS SQL High Availability option as well.

Please or Register to post comments.

What's SQL SELECT Blog?
Blog Archive