In this post we will remove some databases located in Azure.
This related to my last post where I am cleaning up some badly named databases and replacing them with standardised database names.
So we have this situation:
We want to get rid of the top two databases AzureWebAppFunctionalTestDB and AzureWebAppQADB.
So we’ll check we’re logged in:
PS > Get-AzureAccount
If not – then just login
PS > Login-AzureRmAccount
It is always a good idea to list the databases on your server:
PS >Get-AzureSqlDatabase -ServerName $servername
And now we’ll simply remove the database:
# Some variables for our resources
$resourcegroupname = “AzureDEMO_RG”
$databasename1 = “QAAzureWebAppDEMO_DB”
$databasename2 = “FTAzureWebAppDEMO_DB”
Remove-AzureSqlDatabase -ServerName $servername -DatabaseName $databasename1
Remove-AzureSqlDatabase -ServerName $servername -DatabaseName $databasename2
You will then be asked if you really want o remove the database:
Answer appropriately and viola – we have removed our Azure SQL Databases via PowerShell