How to stop a restore of a database with Microsoft SQL Server 2005?

Question

How to stop or cancel or kill a restore of a database with Microsoft SQL Server 2005? Can you give me the request or procedure

score 9 · Accepted Answer · answered May 11 '11 at 13:04

9

In SSMS type sp_who to get a list of open SPIDs (session ID's).

Find the one that contains your Restore. The command will be something like RESTORE DATABASE.

Use kill XXX where XXX is the SPID of that transaction.

answered May 11 '11 at 13:04

JNK

I've got the following error `Only user processes can be killed.` – AlexMelw Jun 12 '17 at 08:55

score 1 · Answer 2 · answered May 11 '11 at 12:48

1

Find this spid and kill them or rollback transaction. Use sp_who for search the spid of restore.

answered May 11 '11 at 12:48

skorpk

6

I did sp_who but the retore is not here, however the Management Studio Express say me Restoring... – Christophe Debove May 11 '11 at 13:04
2

I have the same issue as @Christophe – Jonathan Aug 24 '11 at 05:19
Maybe you are actually looking for the same answer as found in this thread (if DB says "Restoring" but restore process is completed) https://stackoverflow.com/a/521039/1095493 – Nick Niebling Jul 09 '17 at 20:50

2 Answers2