Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Restore Prod database ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Restore Prod database in UAT steps and Post restore steps

(2) ShareShare
ReportReport
Posted on by vicky1234 64

hi ,

I want to restore the UAT database with PROD database and I will be using the "Point in time restore Prod to Sandbox" option.

I have checked the history - > envt changes in LCS and it showed that for type 'refresh database" it only took 1 hours.

Does refresh just creates blank database or it will just copy the current Prod environment.

Also what are the differences with the other option, I mean does it does not copy the dual write settings ? 

What are the steps and time required for this activity provided the fact that it took less than an hour for refresh activity.

Are there any steps which needs to be done post this deployment/(restore) . I have seen on web that we need to take UAT database access and enable the users.

Do we have other specific steps to be followed for this and what setup I will need to do to relink the Dual write setup.

pastedimage1675102670828v1.png

thanks,

VM

  • Suggested answer
    Jaco van der Merwe Profile Picture
    Jaco van der Merwe 9 on at
    Restore Prod database in UAT steps and Post restore steps

    Does refresh just creates blank database or it will just copy the current Prod environment. - Copy of current Production database

    Also what are the differences with the other option, I mean does it does not copy the dual write settings ?  - Dual Write settings (Mapping) does not get stored on the D365FO side. On Power Platform, create a Solution and store it in your custom solution. After the refresh, in Dual Write, import you Power Platform Solution.

    What are the steps and time required for this activity provided the fact that it took less than an hour for refresh activity. - It always takes less than 2 hours for me, attachment documents included. After the refresh, I wrote a SQL script, that updates most of my production config to Test config. Like integrations and customizations etc.

    Are there any steps which needs to be done post this deployment/(restore) . I have seen on web that we need to take UAT database access and enable the users. - One option is, you need to login as the Environment owner and enable everybody, because after the refresh all is disabled, except Admin. You can do this within your SQL script.

    Do we have other specific steps to be followed for this and what setup I will need to do to relink the Dual write setup. - Like mentioned before, you will need to import your Solution(Backup) otherwise all mappings are gone, and then you will need to Sync all data.

    Only steps that are a must - Have Environment Owner Access, just in case you do not know how to connect to SQL. Backup your dual write mappings in a Solution on Power Platform, and make sure your integrations/customization are not pointing to Production resources.

    Hope this helps.

  • Suggested answer
    Manikanda_Gopal Profile Picture
    Manikanda_Gopal 20 on at
    Restore Prod database in UAT steps and Post restore steps
    While I am unfamiliar with dual write, I have mentioned the other necessary steps to follow after a database restoration in my blog
     
     
    Regards,
    Manikanda Gopal
  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,687 Moderator on at
    RE: Restore Prod database in UAT steps and Post restore steps

    PITR option copies prod data to your sandbox environment. Data elements which are not copied during this process are listed on the link below  -

    learn.microsoft.com/.../database-pitr-prod-sandbox

    Steps which are required to be performed after u copy prod data to your sandbox in DW enabled environment are listed below - learn.microsoft.com/.../relink-environments

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 225

#2
Martin Dráb Profile Picture

Martin Dráb 174 Most Valuable Professional

#3
Adis Profile Picture

Adis 132 Super User 2025 Season 1

Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans