SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Failed Backup Job SPID Won't Go Away


Failed Backup Job SPID Won't Go Away

Author
Message
Ed Zann
Ed Zann
SSC Eights!
SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)

Group: General Forum Members
Points: 823 Visits: 1391
The nightly backup job on one of my SQL 2005 servers failed this past Saturday and Sunday night. I backup to our NAS on which I have a disk quota. The SQL error logs indicate an Out of Disk Space condition - which could be - but one of our storage admins also hinted that they may have caused a temporary outage on Saturday. So I don't know the true cause. In any event I have a SPID 55 spawned from the Sunday night's backup that was not killed when the SQL Agent job failed. I killed it this morning (7 hrs ago) but it is still in a KILLED/ROLLBACK status and has a huge 61962953 BACKUP THREAD wait that keeps incrementing, but the Physical IO counter remains unchanged. I need to get rid of this SPID so it doesn't interfere with tonight's backup. What are my options?



Ed Zann
Ed Zann
SSC Eights!
SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)SSC Eights! (823 reputation)

Group: General Forum Members
Points: 823 Visits: 1391
The SPID has disappeared finally. I use Hyperbac on this server. I tried stopping the Hyperbac service but it did not respond normally. So I opened up Task Manager and killed the Hyperbac processes that were running. Moments later the backup SPID
finally went away. So it appears there was some hangup between SQL and Hyperbac.

I restarted the Hyperbac service. ....now we'll see what happens tonight.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search