Home All Groups Group Topic Archive Search About

Database backup stopped and Can't Kill SPID

Author
6 Jan 2006 3:13 PM
Sean John
I created a full database backup on my SQL2000 database and it hung at
the last to bars and wouldnt complete.  I canceled the job and its been
rolling back for over 5 hours.  How can I stop the main SPID?

SPID 76: transaction rollback in progress. Estimated rollback
completion: 100%. Estimated time remaining: 0 seconds.



*** Sent via Developersdex http://www.developersdex.com ***

AddThis Social Bookmark Button