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)

Suggested answer

Mohamed Amine Mahmoudi 26,455 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

please try to Backup/Restore the database from SSMS

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Anthony Blake 2,966 Super User 2025 Season 2 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 238,007 Most Valuable Professional on at

Like (0)

Report

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

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