Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Not enough drive space...
Finance forum

Not enough drive space in Azure DEV environment for database restore

Posted on by 11,627
Hi All,
In order to run data upgrade process in Azure dev environment, I need to restore client's business db in Azure SQL server as described in the below link:
The problem is that the database size is around 250 GB and there is not enough space in any of the drive to run the database restore successfully.
Can anyone in the group please advise if there is any standard procedure through which I can increase the drive space or do I need to raise a service request in LCS for this ?
  • Jie G Profile Picture
    Jie G on at
    RE: Not enough drive space in Azure DEV environment for database restore

    Hi Baber,

    Sorry for my mistake to suggest you open a service request for this issue. Actually you need to open a support ticket with Dynamics 365 for Finance and Operations support team.

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Not enough drive space in Azure DEV environment for database restore

    I have not tried because I don't see why MS would give you extra space for free if there is another way to do this. But try and update this thread so we would know if it is possible.

  • syed baber Profile Picture
    syed baber 11,627 on at
    RE: Not enough drive space in Azure DEV environment for database restore

    Hi Ada,

    In LCS Service request, the DEV environment is not showing in the Environment name drop down. Any clue what could be the issue ?

    Thanks,

    Baber.

  • syed baber Profile Picture
    syed baber 11,627 on at
    RE: Not enough drive space in Azure DEV environment for database restore

    Hi Ievgen,

    Thanks a lot for your help. I will take a look at this, but in the meantime can you please confirm if I can raise a support request to increase drive space on Tier1 DEV Sandbox environment ? I am asking this, because in LCS support -> Service request tab, if I click add and select Other request, then under Environment name drop down, just TEST environment name is showing but not the DEV one. I wanted to request the increase of disk space on DEV VM through LCS support.

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Not enough drive space in Azure DEV environment for database restore

    Next step after Tier 1 is data upgrade in Tier 2 anyway, so you can easily skip it, but if you want here is first article I found www.sqlshack.com/how-to-connect-and-perform-a-sql-server-database-restore-from-azure-blob-storage

  • syed baber Profile Picture
    syed baber 11,627 on at
    RE: Not enough drive space in Azure DEV environment for database restore

    Hi Ievgen,

    I have the environments using Option 1 as I mentioned earlier. Thanks a lot for confirming that I cannot see the VMs on Azure portal because it is MS managed, I have spent so much time to find out why the VMs are not showing under Azure portal. Now coming to my question, can you please further elaborate how I can restore the database to SQL server on 'DEVELOP and TEST' sanbox machine.  You said to restore it directly to Tier 2 from BLOB. I didn't get this, can you please provide some link where this process is explained ? As per my knowledge, the DEVELOP and TEST environment is Tier 1 Sandbox environment and I want to perform all the upgrade task on this machine.

    Thanks,

    Baber.

  • syed baber Profile Picture
    syed baber 11,627 on at
    RE: Not enough drive space in Azure DEV environment for database restore

    Hi Ada,

    Have already checked this, and tried to setup Azure connector but it requires Azure subscription Id to be provided which I can't see in Azure portal.

    Thanks,

    Baber.

  • Jie G Profile Picture
    Jie G on at
    RE: Not enough drive space in Azure DEV environment for database restore
    Hi Baber,
    Would you please check whether you have deployed the VM under client's Azure subscription according to https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/deployment/arm-onboarding  
    Azure connector is required during this process.
    You can go to the project containing this VM in LCS, in the Environment sections, click "Microsoft Azure settings" to check the Azure connector.
    4035.1.PNG
  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Not enough drive space in Azure DEV environment for database restore

    So we need to start from the basics then. There are 2 ways to get Azure hosted Tier 1 environment:

    1) Buy 20 licenses and get free Tier 1 box where you do not have admin rights and it sits in Azure subscription managed by Microsoft. Because this subscription is managed by MS you cannot see it in Azure portal and cannot do anything with it. Then follow my advice from previous post and restore it directly to Tier 2 from BLOB.

    2) Create your own Azure subscription and deploy dev, test or demo VM, during deployment you can select VM size and change it later in Azure portal. 

    So which one do you have?

  • syed baber Profile Picture
    syed baber 11,627 on at
    RE: Not enough drive space in Azure DEV environment for database restore

    Hi Ievgen,

    I have clearly mentioned in my previous response that D365 VM is under client's Azure subscription. My client purchased Dynamics 365 Unified operations license (minimum 20 users). Client admin have given me rights to deploy/redeploy environments, not exaclty sure what do you mean by MS managed. I assume that if I login with same credentials on Azure portal, I would be able to see the VMs there and increase disk space using the process described above by Sukrut. But I cannot see any VMs neither any subscription is showing when I logged in with my user. Is there anything I might be missing ?

    Thanks,

    Baber.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans