I have make a mistake to Move database from Production to UAT

(0) Share

Report

Posted on by Nisha Soni 2709

Hello all,

I follow the below link to move database from Production to UAT. I Production is not working is there any issue occure please help me to get ride it. And please suggest me proper way to move database from Production to UAT

I follow the above steps from Production => Maintain => Move database => Refresh database

and and by mistake my production data is replaced with UAT data.

Can I get my production data back?

Refresh database - Finance & Operations | Dynamics 365 | Microsoft Learn

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report
Copy link

Link copied!
Go to the Environment Details page for your target Sandbox, and select the Maintain > Move database button.

Select the Point-in-time restore option, and then select the desired point in time.

The restoration operation begins immediately.

Was this reply helpful? Yes No
Suggested answer

Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

The proper way to move the database from Production to UAT is to Select UAT Environment>

Note: Just make sure The source environment is Production and the Target environment is Sandbox (UAT)
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/database-refresh

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 303,363 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Nisha,

You mentioned you made a mistake. Can you tell us what this mistake is about? You tried to follow the documentation for refreshing the database, but where did you make the mistake?
Is your production environment having an issue after the database refresh from PROD to UAT? Or is this database not working in your UAT? If the last is the case, are you sure the application version of PROD and UAT was the same? There might be unexpected issues when you move a database where the application version or customizations are different.

If there is really an issue (outage) with your production environment and you are running a Microsoft-managed cloud environment, you can create a severe A ticket for Microsoft Support.

Was this reply helpful? Yes No
Nisha Soni 2709 on at

Like (0)

Report
Copy link

Link copied!

I follow the above steps from Production => Maintain => Move database => Refresh database

and and by mistake my production data is replaced with UAT data.

Can I get my production data back?

Was this reply helpful? Yes No
Verified answer

Anthony Blake 3,063 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It is possible to get it back, MS supports Point in Time restores.

If you follow due diligence and decide you need a production point in time restore there are documented steps, but you must FOLLOW WITH CAUTION! Pay attention to the potential long downtime and other documented issues this may cause.

Engage with MS via a support ticket for their assistance.

Documented steps

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/database-point-in-time-restore#self-service-point-in-time-restore

From the documentation:

Don't do this unless you are certain it is needed and have the correct authorisation.

Was this reply helpful? Yes No
Verified answer

Rachit 4,015 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi Nisha,

You can do a Point in time restore in Production. Also refer to below link having more details of additional things you should take care of.

One thing you should do is to disable all user access in PROD except Admin ( which has been restored by UAT) to avoid any new data getting created in this DB by business users, until things have been restored and validated as fit for business use.

https://github.com/MicrosoftDocs/Dynamics-365-Unified-Operations-Public/blob/main/articles/fin-ops-core/dev-itpro/database/database-point-in-time-restore.md#breaking-the-chain-of-available-restore-points

All the best with your restore and do share your experience here.

Was this reply helpful? Yes No