SQL Server High Availability in a Microsoft Dynamics AX 2009 Environment

If your organization wants to implement high availability for Microsoft SQL Server 2008 R2 in a Microsoft Dynamics AX 2009 environment, you should first understand some of the typical approaches and the risks and benefits of each one as it relates to your overall backup strategy.  If you don't have a backup strategy, it is important to figure one out before choosing which high availability approach is right for you. 

In this article I will explain how database mirroring, failover clustering and, log shipping are used and whether or not those models are viable for a Dynamics AX environment.

Database mirroring


Requires FREE Membership to View

Become a Member Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
About Simon Loiselle

Simon Loiselle is an IT Consultant at Haka Solutions, certified MCTS for MS SQL Server 2008. SQL Server Implementation, Maintenance and Optimization are a growing passion. For more than a year, I've been working with everything IT-related surrounding a Microsoft Dynamics AX environment.

Read full bio...