web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Update Sandbox Databas...
Microsoft Dynamics CRM (Archived)

Update Sandbox Database With Live - CRM 2013

(0) ShareShare
ReportReport
Posted on by WeeGrafter 142

Hi there,

I've recently started using CRM and have noticed that our Sandbox/Dev Database is out of date with our Live Database. It doesn't look like it's been updated for some time.

 

I would like to take a backup of Live and restore into our Sandbox/DEv Database so both are in sync for going forward. 

 

Coming from a Dynamic NAV background, I'd simply backup Live and restore into Sandbox/Dev, simple. Is it the same procedure with CRM 2013? We are using the on-premises version.

Any help would be greatly appreciated.

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jason M. Cosman Profile Picture
    Jason M. Cosman 5,234 Moderator on at

    It is actually pretty straight forward with On-Prem. You can simply take one database of an organization copy it to your sandbox/dev sql server restore it there. Once the database is there use the Deployment manager on the Back End Services server to import the database. The only tricky part is if there different domains you'll have to remap users that you want to have access. Good luck!

  • WeeGrafter Profile Picture
    WeeGrafter 142 on at

    Do you have links to the procedure so I can follow them?

  • Verified answer
    Jason M. Cosman Profile Picture
    Jason M. Cosman 5,234 Moderator on at

    Hello WeeGrafter;

    This is for 2011 but the exact same steps apply: srmscrm.wordpress.com/.../how-restore-the-mscrm-organization-databases-on-the-new-computer-that-is-running-sql-server

    After restoring the database it's important to go to the backend server of your Sandbox/Dev server and use the Deployment Manager.

  • Jason M. Cosman Profile Picture
    Jason M. Cosman 5,234 Moderator on at

    I'd even say for the import process after the SQL database is restored this would be pretty close (even though its 2015) www.c-sharpcorner.com/.../steps-to-import-organization-database-in-ms-dynamics-crm-201 .

  • Jason M. Cosman Profile Picture
    Jason M. Cosman 5,234 Moderator on at

    Good luck Wee; if you have any other questions around this please feel free to ask sometimes the first time with this type of operation can be quiet daunting but once you do it once you'll be a pro!

    Cheers

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans