Database Restoring Stuck

Question

Hi,

I deleted 3 of our databases yesterday. Today I wanted to restore 3 of them. One of them has been restored. Others are stuck. Can you help me?

Answer 1

"Stuck" is nothing we can work on.

I see a screenshot of SSMS with several databases, so it is not "Azure SQL Database", as you tagged your post? It's on-premise SQL Server or a VM?

Then you simply may forgot the option WITH RECOVERY to end the restore process.

If so, execute a simple RESTORE WITH RECOVERY command, see https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-ver16