Creating the deployment would exceed the quota of 800 – Azure Error resolution

While performing multiple Azure operations from portal we get below error. This error occurs while performing multiple operations like creating elastic pool, moving a database to a new elastic pool, creating Secondary database, etc.

Error:
Error submitting the deployment request. Additional details from the underlying API that might be helpful: Creating the deployment ‘Microsoft.SQL.newElasticPoolExistingServerNoDatabases_1ab223232’ would exceed the quota of ‘800’. The current deployment count is ‘800’, please delete some deployments before creating a new one. Please see https://aka.ms/arm-deploy for usage details. (Code: DeploymentQuotaExceeded)

We have to delete few old deployments from history to address the problem. This can be done either using UI or using Powershell. (Note: This deletes only History record but not actual work)

Powershell way of doing it:

#
#Below command lets you login into Azure and execute Rm commands
Login-AzureRmAccount
  
#(his selects production subscription/ Parameters can be changed
Select-AzureRmSubscription -SubscriptionId "34kjh34k-3kj4nh3kj-3434-34j3-ksamk3j4mlk3j" -ErrorAction Stop 
  
#This is to confirm if resource group exists
Get-AzureRmResourceGroup
  
#This lists all Deployments from History - all 800
Get-AzureRmResourceGroupDeployment -ResourceGroupName "myResourceGorupName"

#This command deletes the deployment with given name
Remove-AzureRmResourceGroupDeployment -Name "newDatabaseImportExistingServerV2_222222AAA01222A24Addddd" -ResourceGroupName "myResourceGorupName"
#
#

From Portal:
https://portal.azure.com/ -> Open Resource Groups -> Open the Resource (myResourceGroupName) -> Click on Deployments -> Select one of the deployments and click on Delete -> Click on Yes to proceed with deletion.

Advertisements
This entry was posted in Azure, Uncategorized and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s