Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

Posted by Sebastian Seifert on Server Fault See other posts from Server Fault or by Sebastian Seifert
Published on 2011-01-10T19:32:43Z Indexed on 2011/01/10 19:55 UTC
Read the original article Hit count: 247

Filed under:
|

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.

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2008