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 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 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
#(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
#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: -> 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.

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: Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s