Not enough drive space in Azure DEV environment for database restore

(0) Share

Report

Posted on by syed baber

11,633

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:

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/migration-upgrade/data-upgrade-2012

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 ?

Categories:

Data Integration

Development / Customization / SDK

I have the same question (0)

All responses (20)

Answers (1)

Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

RE: Not enough drive space in Azure DEV environment for database restore

You can do that from the azure portal .

querysurge.zendesk.com/.../115002530951-Azure-Expand-Disk-

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

RE: Not enough drive space in Azure DEV environment for database restore

Did you try to upload it to BLOB and restore it from there ?

Was this reply helpful? Yes No
Jie G on at

Like (0)

Report

RE: Not enough drive space in Azure DEV environment for database restore

Hi syed baber,

In your LCS project settings, you should have added Azure connector. Just visit Azure portal and find your dev VM and double click it, Click Disk in the settings to expand it. Note that you should shut down the VM first.

After restarting the VM, you also need to extend the disk from the disk management tool.

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

RE: Not enough drive space in Azure DEV environment for database restore

Hi Ievgen,

I have uploaded the database backup first to Azure storage using Azure storage explorer and then downloaded the backup to D365 DEV VM. Now I have to restore the PROD database backup to SQL server on DEV VM, but don't have enough space on data and log drive on VM. The business database size is around 250 GB, but none of the drive on the VM has this much space. Hope you understand my point.

I don't understand how I can restore it from BLOB. Can you please elaborate further ?

Thanks,

Baber.

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

RE: Not enough drive space in Azure DEV environment for database restore

Hi Ada,

In LCS project settings, under Azure connectors tab, there is no Azure connectors created. Also, when I logged into Azure portal I cannot see any virtual machine under Virtual machines. Is it because the Azure connector is not setup against the Implementation project in LCS ?

Thanks,

Baber.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

RE: Not enough drive space in Azure DEV environment for database restore

First of all you need to learn the difference between Azure SQL and SQL server because you started from Azure SQL now you talk about DEV VM that has SQL server, how could we help you if you cannot explain what your issue is ?

So if we are talking about dev is it MS managed or deploy to your own subscription ?

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

RE: Not enough drive space in Azure DEV environment for database restore

Sorry for the confusion. Let me explain again. I want to restore PROD backup to SQL server on D365 DEV VM that is deployed under client's Azure subscription. But there is not enough space on data and log drive on DEV VM to restore the backup. So I need to know how can I increase the disk space on DEV VM, so that I can restore the back to SQL server on DEV VM ? My objective is to run the database upgrade package after restoring the database. Hope you understand my point.

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

RE: Not enough drive space in Azure DEV environment for database restore

As already mentioned if you want to have enough disk space , you have to go through azure portal to see your VM and increase disk space

Was this reply helpful? Yes No
Suggested answer

Jie G on at

Like (1)

Report

RE: Not enough drive space in Azure DEV environment for database restore

Hi Baber,

This is the Dev environment from D365FO subscription, so it is managed by Microsoft. You need to open a service request to increate its DB size.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (0)

Report

RE: Not enough drive space in Azure DEV environment for database restore

So you either increase disk size on the VM using Azure portal if it is deployed to your own subscription (you ignored my question if it is MS managed or not that is not helpful again) or go and restore it straight to Tier 2 from BLOB using PowerShell, Tier 2 uses Azure SQL and storage is limited to 1TB per subscription or something like that. You can easily find steps using your favorite search engine.

Was this reply helpful? Yes No