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 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" # #
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.