CODEWITHSUNDEEP
sql-serverrestore
Jeppe Søndergaard
Jeppe Søndergaard

Reputation: 21

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

Upvotes: 1

Views: 755

Answers (2)

Alfie Jin
Alfie Jin

Reputation: 9

The following command will take a database that is in the "restoring" state and make it available for end users.

RESTORE DATABASE AdventureWorks WITH RECOVERY
GO

Upvotes: 0

Jeppe Søndergaard
Jeppe Søndergaard

Reputation: 21

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

Upvotes: 1

Related Questions