Stopping a backup either in progress or while queued

TheHierophant

There is no way to either remove a backup job from the queue, or to kill a backup job while it is in progress.  You may be able to kill the SPID in SSMS, but how do you tell which SPID to kill when you are running several backups in parallel?
You can restart the backup Service, but this kills all of the backups without any tidying up.
It is possible to identify the threads running in a multi-threaded service, it should be possible to interrupt the thread, stop the write operation and pass it to the clean-up routine to handle this cleanly.
It would be nice to have a context menu available from the In Progress form, but a simple button, that took the backup process in focus would be fine.

Dan_J

Hi @TheHierophant

Many thanks for reaching out to us regarding this.

The only way to end an in progress backup job is to stop the SQL Backup Agent service for the instance in question (as mentioned in: https://documentation.red-gate.com/sbu/troubleshooting/stopping-a-backup-or-restore-job-while-in-progress#:~:text=From the Windows Control Panel,the service and select Stop.)

Unfortunately there is currently no other way to achieve this, and no clean up process that goes along with it. I appreciate this would be useful functionality for you, however I'm afraid this is not something the team will be adding to the product any time soon.