Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer 1

Sounds like it may be related to a SQL Server bug. Check out this update: http://support.microsoft.com/kb/961237

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
add comment

Your Answer

 
discard

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.