Finance | Project Operations, Human Resources, ...

PROD Backup in D365FO

(0) Share

Report

Posted on by TonyAx

570

Hi All,

I want to take D365FO PROD server SQL and coding backup like AX 2012. Please explain how to do?

Thanks
Tony

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Martin Dráb 237,987 Most Valuable Professional on at

Like (0)

Report

You can do it on LCS. Please refer to docs: Refresh database for details.

Neither source code nor compiled binaries are stored in database anymore, therefore this part isn't applicable to D365FO.

Was this reply helpful? Yes No
TonyAx 570 on at

Like (0)

Report

Thanks for Reply there is no option Maintain > Move database on PROD server please check below images

Maintain > Move database its available on UAT only please check the below image

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Tony,

For database, you can request the database backup of production to your UAT environment.

Please refer to the following blog:

rahulmsdax.blogspot.com/.../production-database-backup-request.html

If you want to backup/restore the code, you can get the backup on tier-2 environment.

Have a look at the old thread:

community.dynamics.com/.../828793

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,987 Most Valuable Professional on at

Like (0)

Report

Yes, that's correct. The Move database option is used for target environment, not source environments. You can't restore a database from another environment to production. You can see that the first step of instructions says "Visit your target sandbox on the Environment Details page […]".

By the way, production database is backed up automatically. You don't have to do anything for it and you also can't influence it in any way. I assume you want to do something with the data, such as using it for testing - that's when you nee the data refresh procedure.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Moved to the D365 forum.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Tony,

MS makes regular backups of your productive environment and ensures that you system is always up and running.

Why do you want to make an additional/extra backup?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hello Tony,

To add to what Martin and Dr. Ludwig said, you can request for a Prod database back from Microsoft every 15 days. The Microsoft team will send you a backup of the PROD database every 15 days.

Thanks,
Navneeth Nagrajan | Dynamics 365 Technical Consultant

Was this reply helpful? Yes No
TonyAx 570 on at

Like (0)

Report

Thanks for reply, I want to restore the DB from PROD to UAT/DEV so we need backup .

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,987 Most Valuable Professional on at

Like (0)

Report

You can't connect to the production database and take a backup - Microsoft won't give you access. Instead, follow the link I gave you at the very beginning: Refresh database.

Let me quote it:

A database refresh lets you copy the transactional and financial reporting databases of your production environment into the target, sandbox UAT environment.

It's exactly what you need, isn't it?

Was this reply helpful? Yes No