SQL Server backup would not terminate

5 pts.
Tags:
SQL Server Agent
SQL Server Agent Jobs
SQL Server backup
I tried to stop the backup which was already fired through job schedule,but it did't stop. Then I stop the sql serveragent but it also not abled to stop the backup. The backup size was 100GB. Could you please give me the reason and solution of it.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You should be able to kill the backup job by using the KILL statement and giving it the spid that the backup database command is running in.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: