Instance Storage Size in Azure Powershell -

Brass Contributor

So your Managed instance is running out of space? Complete the below to increase the storage space.

::::You will need to install AzureRM if it is already installed 

Step 1

Install-Module PowerShellGet -Force
Install-Module -Name AzureRM -AllowClobber
Install-Module -Name AzureRM.Sql -Force

 

Step 2
Connect-AzureRmAccount
$subId = “my_subscription_id”
$resourceGroup = “ResourceGroupname”
$instanceName = “managedInstancename”

::::set your subscription
Select-AzureRmSubscription -SubscriptionId $subId

::::get the MI details
Get-AzureRmSqlInstance -Name $instanceName -ResourceGroupName $resourceGroup

::::set your new storage size in GB
$size = 4096
Set-AzureRmSqlInstance -Name $instanceName -ResourceGroupName $resourceGroup -StorageSizeInGB $size

0 Replies