Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

CRM 2016 SQL & Application Failover Options & How to Setup

(0) ShareShare
ReportReport
Posted on by 5

Hi all,

I have been handed my first CRM project.....be gentle

We have built a new CRM environment across 2 data centre's, which will have SharePoint integration purely for document storage.  Everything is installed, and working.

We're now looking at failover options, and the business wants full HA, or as close that I can give.

At this point I will explain how our infrastructure is laid out.

We have 2 CRM app servers & 2 SQL servers, one each in data centre A & B.

DC A

CRMAPPSERVER1

CRMSQLSERVER1

DC B

CRMAPPSERVER2

CRMSQLSERVER2

We have 4 different CRM databases, 1 database in DC A (primary DC) & 3 in DC B (Secondary)....I know, i know.  With users directed to their respective data centre, depending on business division.

Configuring failover for SQL is the easy part if users were all in one DC, I could create HA groups from DC A > DC B.

My biggest hurdle is how do I deal with the CRM APP servers, each holds different databases & organisations.  Can I create another HA group from DC B > DC A.  And import the synced databases?  So I have effectively have mirrored app servers and rely on the HA Groups to do the work for me.....though i'm sure those HA databases are read only?

All servers are VM ware.

SQL versions are currently STD, to be updated to ENT.

I'm sure I have missed out loads of info, please ask.

Thanks in advance,

Dave.

*This post is locked for comments

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans