How do I cancel a database restore that is stuck

Patrick Nelson 0 Reputation points
2025-04-15T19:56:50.4233333+00:00

I have a database restore that is stuck and been running for 3 hours. How do I cancel it?

SQL Server Database Engine
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,581 Reputation points
    2025-04-16T08:01:45.7966667+00:00

    How do I cancel it?

    And what for an result do you then expect?

    The old unchanged database, an empty database or a complete broken one?

    An restore takes always much long then the backup, because SQL Server validates first the complete backup file.

    Let it run.


  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.