Database Sync issue after DB restore

(1) Share

Report

Posted on by JJDunaid

226

I have just exported the Database from lcs sandbox and apply it on my fresh Vm but in the visual studio the full database sync is getting failed.

By the way I restore sandbox db from production first then I exported the sandbox db for deployment on fresh VM.

These are the errors:

All responses (7)

Answers (1)

Sort by

Martin Dráb 240,744 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What are the errors?
André Arnaud de Cal... 307,101 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi JJDunaid,

I'm also curious about the exact error messages. Can you also tell us if the application versions of the production and the fresh VM are the same?
Layan Jwei 8,284 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes please share the errors and i would like to know how you restored the DB.

If it was a .bak file and maybe u missed a step. Then please check out my article

https://www.ljdynamicswritings.com/2024/03/how-to-apply-database-backup-from-lcs-to-your-d365fo-devbox-environment.html?m=1

Thanks,

Layan Jweihan
Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

What are the errors? Do you have enough space on your Dev environment? Also you can check my article about restoring Sand box DB to Dev environment:
https://butterflywaeda.hashnode.dev/step-by-step-guide-to-restoring-production-database-in-d365-fo-development

Thanks,
Waed Ayyad
If this helped, please mark it as "Verified" for others facing the same issue
Suggested answer

Navneeth Nagrajan 2,699 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi JJDunaid,

Questions:
1. What are those errors that you receive on your machine?

2. While synchronizing the database are you getting table sync errors or disk space errors etc.?

3. After importing the database (If you have done it manually) have you renamed the database to AxDB?

4. Are there any customizations that exist on the sandbox that is broken?

Suggestions:

1. If you are getting RetailChannelObjects errors then you need to drop the RetailChannelObjects through the script K:\DeployablePackages\<deployablepackagesversionnumber>\RetailServer\Scripts\DropAllRetailChannelDbObjects.sql

2. Re-run your DB sync steps.

Happy to answer questions, if any.
Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks
Waed Ayyad
Verified answer

JJDunaid 226 on at

Like (1)

Report
Copy link

Link copied!

Yes the issue is resolved. I resolved the issue by simply reapplying the DB from sandbox to VM. After re-applying the DB i simply synced the DB the error's were resolved.