D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Database Copy Cloud Hosted Environment to Cloud Hosted Environment

  • 1.  Database Copy Cloud Hosted Environment to Cloud Hosted Environment

    Posted Dec 17, 2019 03:03 PM
    Hello,

    I have been tasked to duplicate one of our cloud hosted environments to a new cloud hosted environment.  Is there a best practice for handling the database restore process?  Setting up a new empty D365 environment is not hard, I'm just not clear on how to handle the data end of this request.  There is a ton of data management documentation for the LCS managed environments but seems to be minimal information regarding this topic.

    #FinanceandOperations #Technical #DataManagement ​​​​​

    ------------------------------
    Thanks,

    Dave Cagle
    GSP Marketing Technologies
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Database Copy Cloud Hosted Environment to Cloud Hosted Environment

    Posted Dec 18, 2019 03:38 AM
    Hi Dave,
     Totally understandable. However, you task is slightly simple if you duplicating the cloud-hosted environement.
    • Spin your new cloud-hosted from LCS
    • connect to same brach, so no issues when importing the database file.
    • import .bak file {on your source cloud-hosted box, make DB backup as .bak type}
    • Synch using VS or script
    let me kwow if any issues, or further questions, please.
    Thanks
    Mo

    ------------------------------
    Mohammad Arif
    Solution Architect
    Dentsu Aegis Network
    Livingston SC
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: Database Copy Cloud Hosted Environment to Cloud Hosted Environment

    Posted Dec 18, 2019 03:26 PM
    Thanks Mo!

    Just so I am clear on the last two steps.  I import the source database to the newly created SQL server and run a synch from VS.  Do I import the source database as a different database in the new SQL Server?

    I will give this a shot and let you know how it goes.

    Thanks,

    Dave

    ------------------------------
    Dave Cagle
    GSP Marketing Technologies
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: Database Copy Cloud Hosted Environment to Cloud Hosted Environment

    Posted Dec 19, 2019 03:40 AM
    Hi Dave,
     You will restore the database (.bak) over the existing one. You will need to stop services & IIS while importing.
    Once the .bak file import done, start the services and do the synch.
    Let me know if any issues, please.

    Thanks
    Mo


    ------------------------------
    Mohammad Arif
    Solution Architect
    Dentsu Aegis Network
    Livingston SC
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: Database Copy Cloud Hosted Environment to Cloud Hosted Environment

    Posted Jan 09, 2020 08:53 AM
    Hi Mohammed,

    I have the same question. Could you please be more specific on what services I need to turn off. on IIS i stopped the AOS. Do I have to do more?
    All I have tried so far, my restore fails as I dont get exclusive access to the DB.

    Thanks!

    ------------------------------
    Joe Gramann
    Director, IT Solutions Architecture
    Britax
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: Database Copy Cloud Hosted Environment to Cloud Hosted Environment

    GOLD CONTRIBUTOR
    Posted Jan 10, 2020 08:55 AM
    You have to turn off those :
    Management Reporter 2012 Process Service
    Microsoft Dynamics 365 for Operations - Batch Management Service
    World Wide Web Publishing Service

    Of course you have to close open query in SSMS.  If it still fails, use the SSMS Activity Monitor to see what connections are open on Axdb.

    ------------------------------
    Steeve Gilbert
    Software Development Supervisor
    Boa-Franc S.E.N.C.
    QC, Canada
    ------------------------------

    Conference-AXUG_200x200


  • 7.  RE: Database Copy Cloud Hosted Environment to Cloud Hosted Environment

    Posted Jan 10, 2020 09:28 AM

    Hi Joe,

    Please

    Stop D365 & IIS

    ---including MR

    Stop SQL server as well. Otherwise you'll not be able to overwrite the database.

     

    Let me know and will be happy to help

     

     

    Regards

    Mohammad

     




    Conference-AXUG_200x200


  • 8.  RE: Database Copy Cloud Hosted Environment to Cloud Hosted Environment

    Posted Jan 10, 2020 09:29 AM

    Hi Joe,

    Please 

    Stop D365 & IIS

    ---including MR

    Stop SQL server as well. Otherwise you'll not be able to overwrite the database.

     

    Let me know and will be happy to help

     

     

    Regards

    Mohammad

     

     

    Regards

    Mohammad




    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role