abort a job in progress

dhtuckerdhtucker Posts: 40 Bronze 2
edited June 29, 2010 11:43PM in SQL Backup Previous Versions
Is there any way to cancel or abort a backup job once it's launched?

I just started a "backup up every database on this server" job, only to discover the agent doesn't seem to have write privilege to the backup folder. So it's now slowly and methodically failing each database in turn, and I can't seem to find the off switch! Restarting the SQL Backup interface doesn't help, even restarting the SQL Backup Agent service doesn't seem to dissuade it - it just keeps plugging along (failing).
Doug Tucker
Software Engineer / DBA
RenWeb School Management Software

Comments

  • dhtuckerdhtucker Posts: 40 Bronze 2
    I thought maybe it'd stop if I deleted that server from the group.

    Good news:
    Yes, that stops a job in progress.

    Bad news:
    It also caused SQL Backup I/F to crash (invalid object reference)
    and the SQL Backup Agent on that server stopped.

    Not quite the solution I was looking for... :oops:
    Doug Tucker
    Software Engineer / DBA
    RenWeb School Management Software
  • peteypetey Posts: 2,358 New member
    There isn't a command to stop a backup task once it's been started. Next time, try closing the GUI, then stop the SQL Backup Agent service for a minute or so.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.