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

How to stop or cancel or kill a restore of a da开发者_如何学编程tabase with Microsoft SQL Server 2005? Can you give me the request or procedure

---

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.

---

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