Search code examples
sql-serverrestore

SQL Server hangs when trying to restore full-copy backup


I am trying to restore a database from another SQL Server. I am running SQL Server 2016. The database is 268 mb. When I execute the restore command, either from the SSMS wizard or from a query, it never gets out of the restore execution.

Any suggestion how to fix this?

enter image description here


Solution

  • Two cups of coffee later ~40 minutes the restore seems to have completed. Patience