Restoring of database stuck / failed

Question

I have tries to restore a database backup.

I just created a new db and choose a backup as the source, The db is not to big, its about 13gb.

I'ts been running for over 3 days now. There is no sign of the new database on azure portal, however in SQL management studio, it lists it there?

TITLE: Microsoft SQL Server Management Studio

------------------------------

Database 'Migrationtest' on server 'xyz' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of '{EFF361ED-0260-45EA-A9CA-AC88BD227257}'. (Microsoft SQL Server, Error: 40613)

For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-40613-database-engine-error

------------------------------

I can't delete this db in azure or SSMS

Answer 1

How did you perform the restore, with plain SQL? Have you add the option WITH RECOVERY?
With option WITH NORECOVERY the database engine waits for further differential/log backups to be also restored.
If so, use option WITH RECOVERY ONLY to finish the restore process.

See https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-ver15
=> Comparison of RECOVERY and NORECOVERY

Answer 2

when i am trying to restore database in sql server management studio it is failing