Home > Articles

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Choosing the Appropriate SQL Server High Availability Alternative

IT professionals designing the back-end database infrastructure for SharePoint are faced with the dilemma of choosing the right high availability technology for their solution. If the Service level agreement at the organization requires a hot standby server to be available for immediate failover, failover clustering and database mirroring in High Availability Configuration mode are the right choice. The failover is nearly seamless for the administrator and clients. If a warm standby server, wherein a less expensive, but not as immediate solution is required, log shipping and database mirroring in High Protection or High Performance mode should suffice. In this scenario, failovers must be conducted manually and the clients will be initially affected. Finally, other factors that affect these decisions are cost, hardware, and site proximity.

  • + Share This
  • 🔖 Save To Your Account