How to stop an SQL Maintenance Plan

I started an on demand backup of a test database to a network share just to see if it would work.  I know now that it will not but I would like to kill the  task.  What is the best way to do this.
krlseidlAsked:
Who is Participating?
 
cyberkiwiCommented:
It will time out by itself after a short while so nothing needs to be done?

Otherwise, you can run this to check what is running

sp_who2 active

And if you see the SPID doing a "backup" action, you can kill it using

kill 56

(if 56 is the process doing the backup)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.