SQL Server High Availability best practices


This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

If Microsoft SQL Server high availability services such as failover clustering, mirroring, or log shipping are running in your environment, consider the following best practices:

  • Set up high availability only in your production environment.

  • Disable any high availability service when you perform any operations that might change the database structure and require synchronization. For example, disable log shipping when you apply updates, or when you synchronize the database so that it includes changes from the Application Object Tree (AOT).

For detailed recommendations on how to set up a Microsoft Dynamics AX system for high availability, see SQL Server topology recommendations for availability and performance.