Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Are you backing up the transaction log or doing a full backup? – mrdenny Jan 10 '11 at 19:51
It's a full backup of the database. Recovery Mode is set to SIMPLE. – Sebastian Seifert Jan 10 '11 at 19:54
Honestly that wasn't the answer I was expecting. A full backup shouldn't be changing much, except switching the changes bit on all the blogs that have changed. What's the data change rate between full backups? – mrdenny Jan 10 '11 at 21:09
Sorry, maybe I didn't get your question. Backup was initiated executing following command from windows shell `sqlmaint -S .\sql2008 -U "sa" -P "..." -D DB -Rpt d:\log\DbBackup2008.log -BkUpDB D:\Backup\ -BkUpMedia DISK -CrBkSubDir -DelBkUps 1days -VrfyBackup' – Sebastian Seifert Jan 11 '11 at 8:50

Sounds like it may be related to a SQL Server bug. Check out this update:

share|improve this answer
Unfortunately it doesn't look like it is related since I have a 2008 R2 and am not using a linked server. Nevertheless - thank you. – Sebastian Seifert Jan 11 '11 at 8:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.