Database Restoring Stuck

innAdmin 20 Reputation points


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?

User's image

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 40,736 Reputation points

    "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

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful