locked
Database Backup/Restore in CRM with latest data RRS feed

  • Question

  • I have 2 organisations in CRM 4.0 on the test server.I want to have the 2 databases in sync with each other.I have taken the backup of one database (which has latest data) of 1st organisation and restored it onto another db of 2nd organisation. After restoring when i try to access the 2nd organisation from UI, I am getting error user id is invalid. No user is able to access it.I have checked that the db are now in sync with each other.

    Where is the problem?

    Thursday, September 25, 2014 8:22 AM

Answers

  • Hi,

    I haven't done that sort of restore but you are not restoring the database that was in place. I'm not entirely sure exactly what happens when you do a restore but since you are getting authentication problems something's not quite set up. If you are importing an organization from the same AD the user match will be very simple so to import the organization with the Deployment Admin tool you will get stuff working.

    We could of course argue about why it's not working with a pure db restore but I suppose the thing you really want is to get the test environment up so I would just use the import.

    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

    • Marked as answer by Bachchan11 Monday, October 6, 2014 11:28 AM
    Friday, September 26, 2014 8:53 AM
  • technically, your restore on database should work. But you got to keep in mind that there are two databases for dynamics CRM. Mscrm_config database stores the server, user and a host of other information.

    there is a potential that some of the users created are not available. Import wizard takes care of creating a new organisation id etc.

    basically database consistency is far more important than spending additional time to follow documented process.

    regards

    Jithesh

    • Marked as answer by Bachchan11 Monday, October 6, 2014 11:28 AM
    Saturday, September 27, 2014 10:32 AM

All replies

  • Hi,

    If you delete the organization in the Deployment Manager (disable and then delete) and then do a re-import of the organization you should be able to access the organization. I don't know exactly what happens in the config-db but I haven't been able to "just" do an organization db restore and have it work so there is some sort of difference between the config dbs.

    Hope it helps.


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

    Thursday, September 25, 2014 8:34 AM
  • Hi Rickard,

    Thanks for the answer. But I know  the reimport of organisation. I have done it before.What I am trying to ask here is that if I want to have my organisation with the latest data then everytime I have to import organisation??Cant it be done only by taking backup and restore of db??

    Thanks in advance

    Thursday, September 25, 2014 12:57 PM
  • Hi,

    I haven't done that sort of restore but you are not restoring the database that was in place. I'm not entirely sure exactly what happens when you do a restore but since you are getting authentication problems something's not quite set up. If you are importing an organization from the same AD the user match will be very simple so to import the organization with the Deployment Admin tool you will get stuff working.

    We could of course argue about why it's not working with a pure db restore but I suppose the thing you really want is to get the test environment up so I would just use the import.

    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

    • Marked as answer by Bachchan11 Monday, October 6, 2014 11:28 AM
    Friday, September 26, 2014 8:53 AM
  • technically, your restore on database should work. But you got to keep in mind that there are two databases for dynamics CRM. Mscrm_config database stores the server, user and a host of other information.

    there is a potential that some of the users created are not available. Import wizard takes care of creating a new organisation id etc.

    basically database consistency is far more important than spending additional time to follow documented process.

    regards

    Jithesh

    • Marked as answer by Bachchan11 Monday, October 6, 2014 11:28 AM
    Saturday, September 27, 2014 10:32 AM
  • You can consider instance adapter to you are looking for syncing two organizations Check this

    Microsoft Dynamics CRM Training|Our Blog | Follow US | Our Facebook Page | Microsoft Dynamics CRM 2011 Application Design
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    Monday, September 29, 2014 2:38 AM
    Moderator