Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)
- by Sebastian Seifert
I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer.
Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG.
How can I get these backup processes to stop so they release resources?
Simply killing the processes doesn't work. The process will stay in KILL/ROLL for a long time. This didn't change for several hours.