Mh (3/25/2008)
I am using SQL Litespeed tool for the restore of a database backup, can someone let me know how I can stop the restore as it looks like the restore is hung, Thanks!!
Find the processes id and files it is using through handle.exe and then kill the handle that process id is making use of restoring backup file.
To get handle information, please execute handle.exe -p LiteSpeed32.exe
once you get the information, pick the handle information which is in hexadecimal format and this is followed immediately with a colon.
once you get the information, you can execute handle.exe -c hexadecimal value -P process name or id.
This will teriminate the restore processes rather than killing all the processes that are used by litespeed i.e backups etc if you kill the litespeed through task manager.