My db does not show up in my Azure Portal

Question

I renamed my database from XX to YY from my SSMS, I can access it from SSMS, but I don't see it from my Azure portal. What should I do?

Answer 1

Try to rename it again using Query Editor in Azure Portal.

ALTER DATABASE [XX] MODIFY NAME = [YY];

Do you see any active connections to the database? Use the following query to verify and kill the connections you see.

SELECT session_id, host_name, program_name
FROM sys.dm_exec_sessions
WHERE database_id = DB_ID('YY');

Open Azure Portal on a private window in your web browser, search for the Azure SQL logical server and make a click on the Databases option on the vertical menu.

Answer 2

Thank you !

Answer 3

I appreciate your help. I did the following to the database to solve this issue:

1. Exported it,
2. Dropped it,
3. Imported it.

Thank you again.