Trying to kill suspened job without rebooting the server
Posted on 2010-11-19
We're trying to kill a suspended job without having to reboot the server because it is the production database.
We ran a query yesterday to backup the database to a mapped drive but then cancelled the query.
The task state of the job has been suspended now for 24 hours and the command is KILLED/ROLLBACK
Do we have to restart the server to kill this process?
And if so, is there any risk invloved in the database starting up again