Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / I have make a mistake ...
Finance | Project Operations, Human Resources, ...
Answered

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

(0) ShareShare
ReportReport
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?
 
  • Verified answer
    Rachit Profile Picture
    Rachit 4,015 User Group Leader on at
    I have make a mistake to Move database from Production to UAT
    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. 
     
    All the best with your restore and do share your experience here. 
     
     
  • Verified answer
    Anthony Blake Profile Picture
    Anthony Blake 2,201 Super User 2024 Season 2 on at
    I have make a mistake to Move database from Production to UAT
    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
     
     
    From the documentation:
     
    Don't do this unless you are certain it is needed and have the correct authorisation.
  • Nisha Soni 2709 Profile Picture
    Nisha Soni 2709 on at
    I have make a mistake 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?
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,759 Super User 2024 Season 2 on at
    I have make a mistake to Move database from Production to UAT
    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.
  • Suggested answer
    Umesh Pandit Profile Picture
    Umesh Pandit 9,298 User Group Leader on at
    I have make a mistake to Move database from Production to UAT
    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
  • Suggested answer
    Umesh Pandit Profile Picture
    Umesh Pandit 9,298 User Group Leader on at
    I have make a mistake to Move database from Production to UAT
    1. Go to the Environment Details page for your target Sandbox, and select the Maintain > Move database button.
    2. Select the Point-in-time restore option, and then select the desired point in time.
    3. The restoration operation begins immediately.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans