locked
CRM 2011 Disaster Recovery Question RRS feed

  • Question

  • Hello all;

    New to the forums and have a big question in terms of disaster recovery for a client.

    Here is the current setup; this is an on-prem environment that has a production environment with five servers for each of the server roles including a SQL Server. There is also a test environment that mimic’s the production environment in terms of scale and size of production. The production SQL databases are mirrored back real time to a DR Instance on the Test SQL server box. I’ve done a lot a research in terms of what needs to happen if a DR occurs in terms of what needs to be modified but is there any guide out there for this type of plan? Essentially I understand as soon as I change the registry to the new DR Instance in test the MSCONFIG still has all of the production servers in its database which are no longer valid. I need to change them to be the test environment servers.

    Can anyone point me in the right direction in terms of what would be the steps to do something in this nature?

    Thanks; I know it’s a complicated question.

    Wednesday, April 10, 2013 10:29 PM

All replies

  • What technology are you using for the mirroring ? If it's SQL Server mirroring, then you should be able to modify the ConnectionString values in the Organization table in the MSCRM_Config database to include the FailoverPartner attribute to point to your mirror SQL server

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, April 11, 2013 2:24 PM
    Moderator