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:

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

JJDunaid 226 on at

Like (1)

Report

Database Sync issue after DB restore

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.

Was this reply helpful? Yes No
Waed Ayyad 8,936 Super User 2025 Season 2 on at

Like (0)

Report

Database Sync issue after DB restore

Hi,

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

Thanks
Waed Ayyad

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,174 Super User 2025 Season 2 on at

Like (0)

Report

Database Sync issue after DB restore

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.

Was this reply helpful? Yes No
Waed Ayyad 8,936 Super User 2025 Season 2 on at

Like (0)

Report

Database Sync issue after DB restore

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

Was this reply helpful? Yes No
Layan Jwei 8,034 Super User 2025 Season 2 on at

Like (0)

Report

Database Sync issue after DB restore

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

Was this reply helpful? Yes No
André Arnaud de Cal... 298,647 Super User 2025 Season 2 on at

Like (0)

Report

Database Sync issue after DB restore

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?

Was this reply helpful? Yes No
Martin Dráb 236,172 Most Valuable Professional on at

Like (0)

Report

Dynamics Finance and operation Database Sync issue

What are the errors?

Was this reply helpful? Yes No