Options

AlwaysOn function in SQL 2014 (an 2012)

CarlesTACarlesTA Member Posts: 11
edited 2015-07-08 in SQL General
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

Comments

  • Options
    bbrownbbrown Member Posts: 3,268
    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.
    There are no bugs - only undocumented features.
Sign In or Register to comment.