Share via

Delete MSSQL database which shows as not found but a cost is allocated in cost analysis

Anonymous
2025-10-20T03:47:21.2533333+00:00

Hi, I want to delete this database from our server but in the overview in azure portal it shows as resource not found but in the cost analysis it shows an allocated cost for the resource? How can I delete this?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kalyani Kondavaradala 3,145 Reputation points Microsoft External Staff Moderator
    2025-10-21T09:42:43.6966667+00:00

    Hi redberyl IT,

    Thank you for posting your query on Microsoft Q&A!

    Can you please try the below Steps to resolve:

    1. Confirm the Resource ID and Subscription
    • Go to Cost Management > Cost Analysis
    • Filter by Resource Name or Resource ID
    • Copy the full Resource ID and Subscription ID for reference
    1. Check via Azure CLI or PowerShell

    Sometimes the portal view is stale or broken. Use CLI to confirm if the resource still exists:

    az resource show --ids <resource-id>

    If it returns ResourceNotFound, it's likely deleted but metadata or billing artifacts remain.

    1. Check for Soft Delete or Backup Retention

    For databases (SQL, PostgreSQL, MySQL), Azure may retain backups or metadata for recovery:

    • Go to Recovery Services Vaults or Backup Center
    • Look for any retained backups or soft-deleted instances
    • Delete them manually if found
    1. Review Resource Locks

    Check if a resource lock is preventing full deletion:

    az lock list --resource-group <rg-name> --resource-name <resource-name> --resource-type <type>

    Remove any locks:

    az lock delete --name <lock-name> --resource-group <rg-name>

    Please refer the Microsoft Document :

    https://free.blessedness.top/en-us/azure/backup/backup-azure-delete-vault?tabs=portal

    Can you please share the screenshot of what you are seeing in Azure portal, are there any subnets or SAL present for that resource?

    Thanks!

    Kalyani

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.