I started a restore (point in time) of a Azure SQL Database and after long time running I decided to cancel the deployment.
The source is a S6 and set the target to S3 (database sizes are the same).
During the process I monitored using sys.dm_operation_status . After almost 2 hours the state changed to Cancelled with 100% complete.
After all the database is not listed on sql server (azure portal) but it is listed on my SSMS (18.11.1).
When I try to drop that database using T-SQL Drop Database I have an error message Database 'xxxxxxxx2022-04-12T16-20Z' does not exist.
Also I checked the sys.database. I see that database listed but it is the only row with field is_brocker_enabled = 0
If I try to delete using the SSMS interface I see the error
Cannot connect to sxxxxxxxxx.sql.database.windows.net.
Login failed for user '<token-identified principal>'. (.Net SqlClient Data Provider)
How can I remove that database? (I have all permissions to admin)