Database Restoring Stuck

innAdmin 20 Reputation points
2024-03-07T16:02:36.1433333+00:00

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?

User's image

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 40,736 Reputation points
    2024-03-07T19:23:14.5466667+00:00

    "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

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful