ROOT CHECK

Update: If following method is not working have a look at this  Changes in SQL Script to restore bacpac file for D365FO Many times to debug the Production environment issues we might need live data to address that issue in such case first of all we need to refresh the UAT/Sandbox database with the Production environments database and then afterward we need to export the UAT database to the Asset library from where we can get bacpac file for that UAT database which is then to be imported in your cloud-hosted or one-box environment. This blog and video demonstration will help you to restore your production or UAT database to a cloud-hosted environment. Step 1: Rename existing db  In this step, we need to rename the existing AxDB for safety purposes. Just go to the SSMS application and execute the following command:-   ALTER DATABASE [ip_ent_site] SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO ALTER DATABASE [ip_ent_site] MODIFY NAME = [ip_ent_site_new] GO ALTER DATABASE [ip_ent...

Here in this blog we will see how to import database of production environment in UAT for D365 Finance and Operations.In D365 Finance and Operations when you want to move production data in to your UAT environment for testing or special case where you want to perform section you need to Perform refresh database operations. Here are the steps how to refresh the databases as follows:- click on maintain and select move database In the LCS select full details option for desired project and select environment where you want to import your database and now click on maintain button as follows and select move database option as follows select methods among move database option here select "refresh database" option to import prod database into your UAT / Tier 2 or greater than that environment Here is also option point in time restore where you can restore system from previous time here you can find details about it in this  link . select source environment from where data will be imp...