unable to see azure database

If your Azure database has been deleted, you may still have the option to restore it if the deletion occurred within the last five days. Here are the steps you can follow to restore a deleted Azure Database for MySQL Flexible Server:

1. Check Backup Availability: Ensure that the backup for the server is still available and has not been deleted from the system.
2. Prerequisites: You will need the following information:
   • Azure Subscription name hosting the original server.
   • Location where the server was created.
   • The resource group where the deleted server previously resided must exist. If it no longer exists, create a new resource group with the same name before attempting the restore.
3. Restore Process: Follow the recommended steps to recover the deleted Azure Database for MySQL Flexible Server resource within the five-day window.

If you are using Azure SQL Managed Instance, you can restore a deleted database using the Azure portal, Azure PowerShell, or the Azure CLI. You can find the deleted databases in the Azure portal under the Backups section of your SQL managed instance.

If you need further assistance, please provide more details about the type of database you are trying to restore.

Hello Umair Dil,

It sounds like you're facing some challenges with your Azure database not being visible in your subscription. Here are a few steps you can take to troubleshoot the issue:

Check Server Status: Log in to the Azure portal, navigate to All Resources, and filter for your MySQL server. Ensure that your server is not in a stopped state. If it is, select Start to get it running.

Database Deletion: Since you mentioned that the database was deleted, check if it was a soft delete. Azure often provides recovery options for deleted resources. Look into the Restore functionality to see if the database can be restored.

Backend Refresh: If you still can't see your database, there might be a visibility issue due to a backend refresh. In such cases, reach out to Azure Support to perform an ARM refresh operation, which can help with the visibility problem in the Azure portal.

User Permissions: Double-check whether there have been any recent changes in your Azure subscription or user permissions. It’s crucial to ensure that your access levels have not been altered.

Could you please reply to below queries for us to investigate further?

What type of database are you using? (e.g., MariaDB, SQL Database, etc.)
When was the database last visible to you?
Are there any recent changes made to your Azure subscription or user permissions?
Have you checked if the deletion was a soft-delete or if there are recovery options available?

References:

Azure MySQL Migration Documentation

How to Restore a MySQL Server

Monitor Server - Configure Alerts