Thursday, May 16, 2013

CRM 2011 & database mirroring

In most scenarios where you implement CRM 2011 in Enterprise segment you would choose for database clustering. The advantage is that your setup is easy, at least I think so :) You have virtual name for your SQL server no need for extra CRM configuration.


Another alternative is to choose for database mirroring, also supported scenario. Please keep in mind that besides configuration of SQL server is more complex. You also need to make changes to CRM, which can be forgotten easily.

For example you need to change some settings in the registry on the server where the web application is installed:

1) Locate:  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM\
2) Change: configdb

Data Source=MSCRM_Primary\SQL1;Failover Partner=MSCRM_Mirror\SQL2;Initial Catalog= MSCRM_CONFIG;Integrated Security=SSPI



You can image when you do node switch and forget this entry your CRM application will crash. More details at: http://technet.microsoft.com/en-gb/library/hh699791.aspx.

More background about database mirroring:
http://www.c-sharpcorner.com/uploadfile/nipuntomar/sql-server-database-mirroring-part-1/

PS If you wondering about the image, read this article about Droste Effect  :-)



No comments: