Database movement in D365 F&O

(1) Share

Report

Posted on by BP-09051132-0

I am restoring the local SQL server database from the development environment, but I got an error at the restore time.so can you suggest the solution to this error?

Note :- I want to get backup from the CMD/Power Shall.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

please try to Backup/Restore the database from SSMS

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Anthony Blake 3,162 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The escape /sdn: is the database name, are you sure your database name is AxDB_Backup.bak and not just AxDB or AXDB_Backup without the .bak?

Was this reply helpful? Yes No
MuthukumaranAX 2,903 on at

Like (0)

Report
Copy link

Link copied!

can you explain what exactly you are trying to achieve here?

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

SqlPackage is used for bacpac files, while you said you want to restore a bak file.

In Powershell, you can use Restore-SqlDatabase, for instance.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you are restoring db from development environment then you would get .bak directly which you can restore directly to any other dev vms. But the process you were doing is converting from .bacpac to .bak which is not required.

Can you give full detail what you are trying to achieve?

Was this reply helpful? Yes No