locked
[CRM 2011 Onpremise] Interchange Live and Live Replica DB pointers. : RRS feed

  • Question

  • Hello CRM Gurus,

    We have existing 2011 on premise installation, we have two Database one called "Live" and other is copied instance called "Live Replica", we had issue in "Live" DB and we reconstructed that DB again and updated "Live Replica", Now, we want to make "Live Replica" to be our "Live" instance which should be accessed using same URL we are used to access "Live" CRM. 

    What should be best process to add our current live instance to some other CRM organisation and made "Live Replica" to be our live instance which should be accessed from the URL live was getting accessed from now onwards.

    Should I just rename replica Database to the name as Live and it should pick that up ? Would that be supported step ?

    We have CRM and DB server installed in different server.

    Regards,
    Hiren.

    Thanks and regards,
    Hiren Solanki.
    Please vote or mark as a answer if it helped you.

    Tuesday, February 10, 2015 7:30 AM

All replies

  • Hi,

    Do you have to databases in the same server instance or are there two different servers?

    If they are on the same server and instance, in theory, you should just be able to rename ORG_MSCRM to something else and then rename ORG-REPLICA to ORG_MSCRM, but there might be implactions. However, you might be able to try that and if everything goes down the drain you should be able to remove the organisation from the deployment tool and reimport it. You might also be able to backup the replica and restore it to the live db, but that might be extra work.

    I would probably disable and delete the current organisation and then do whatever db operations you want to do and finish with an organisation import.

    If you have a test system you can try that and see what happens.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Tuesday, February 10, 2015 9:40 AM
  • Hi Rickard,

    Thanks for the opinion.

    You are correct, I have 2 DBs on same SQL instance.

    I just wanted to make sure that renaming DB directly would not make any problem. Otherwise i would have to take backup of 2 Db and then restore that with new DB created and then add them again via deployment manager ( by disabling and deleting organisation first).

    [Update]

    If I restore backup of replica onto Live DB with full overwrite, would that cause any issue on whole CRM access ?

    [/Update]

    Regards,

    Hiren.


    Thanks and regards,
    Hiren Solanki.
    Please vote or mark as a answer if it helped you.


    Tuesday, February 10, 2015 10:26 AM
  • Hi Hiren,

    The thing is that I'm not sure if stuff will break. You should be able to restore it if you have a db backup that you restore and import as a "new" org using the deployment administration tool.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Tuesday, February 10, 2015 10:28 AM