AlwaysOn function in SQL 2014 (an 2012)

CarlesTA

Hi folk,
do you know the "always on" functionality in SQL Server using a Dynamics Nav installation?

This would be usefull for the same company with multiples instances of SQL Server, having all databases accessible together. Is there a recommendation or any white sheet about Alwayson?
If not, have any of you did a setup with a multicompany with diferent location between them?

thanks in advance
Carles

bbrown

AlwaysOn is for fault tolerance. It is not for load balancing or other multiple active database scenarios. Only the currently active database is accessible to users in a read/write manner.