web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / D365 Finance and Operations Technical / Post-PROD DB Restoration Steps

Post-PROD DB Restoration Steps

Views (4)
Manikanda_Gopal Profile Picture Manikanda_Gopal 22
Hi Everyone, 

While many resources explain the process of performing a point-in-time restore from Production to Sandbox in Dynamics 365 Finance and Operations, post-restore steps are often overlooked. This guide outlines essential actions to take after a successful database restoration.

Steps:
  • Verify Data Integrity: Open a frequently used form to ensure that the latest PROD data has been copied to your UAT environment.
  • Enable User Accounts: After a restore, user accounts might be disabled. Navigate to the System Admin module, go to the Users form, and enable the necessary user ID’s.
      

        
  • Email batch job:  Enable the email distributions batch job if required.
  • Custom alerts: If the custom alters are configured in the production environment, disable it.
  • Email parameters: Remove the email parameter setting that currently points to the PROD environment and change it to point to the UAT.
        
  • This step is necessary if your system has integrated with third-party applications and may not be applicable to all users.
  1. Microsoft Entra ID: Change the Microsoft Entra ID application ID that points to the production environment to the UAT application ID.
  2. Azure Key Vault parameters: Remove the secrets, delete the key vault setups, and reconfigure them with the UAT values.
  3. BYOD: Ensure that your BYOD data source is configured to point to the UAT instead of the PROD. Replace the PROD application ID with UAT in recurring integration data projects(DMF). Set the recurring integrations batch job to "Waiting" status from "Withhold".
  4. Endpoints: Configure the business event endpoints if it's required.
  • Export backup: Once all the above steps are completed, export a database backup from the UAT environment. This backup can be used to restore the latest database to development machines.

Comments