High Availability Configuration

Question

Hello everyone, 
 I wanted to know if there is a configuration mode for achieving high availability in case of server failure. For instance, is it possible to set up a configuration like a farm with multiple servers using the same database? 
 Thank you and regards.

Shawn.Ferrier · Answer

Hello, graziano. 
 Indeed, Active Roles does support - and recommend as "Best Practice" - that you should always have at least two AR servers to eliminate single-point-of-failure. You could also use a DNS alias to connect to your AR servers, allowing you the opportunity to manage which server(s) the DNS alias resolves to. In some cases, customers may also opt to use a load-balancer or similar device to manage that DNS alias automatically, which would allow you to do things like load-balance by alternating which server the alias resolves to, and automatically remove servers from the resolution pool if they become unavailable. 
 In turn, these servers should/can be connected to some kind of highly-available SQL infrastructure: cluster (most common), replicated, mirrored, or cloud-hosted. 
 Hope that helps? 
 Shawn