OS: windows server 2003 database version: sql server 2005
i want to kill user process.when i tried to kill user process using its spid... kill 57 i got error SPID 57: transaction rollback in progress. Estimated rollback completion: 52%. Estimated time remaining: 448373 seconds. i also found that this process has suspended status and wait_type is BACKUPTHREAD one more thing i wait to complete rollback transcation since last 3 days. but after 3 days getting same error and estimated time increase every time i issue KILL command. even i tried activity monitor to kill process.but no luck is there any way to slove this issue??? how to kill this process.?? well i havnt try to stop and restart sql server processes.because its producation server.will database complete shudown and server process restart help to overcome this issue. your help is really appreciate. thanks, saurabh
thanks well i tried dbcc inputbuffer(spid)..already but nothing is there.it just give me eventinfo about my backup. and when i tried to delete that backup on backup server.that wont work either.
bcz my backup script is failed.see we take backup everyday through backup script.that is work fine till 3days ago and still working fine for other database todate.but its failed somehow for particular this database.so i want to kill that process and want to restart my backup again.this process now in suspend status so even its not let me delete whatever backup was taken through script.
nope..nothing bcz of script.only problem is my rollback process looks like blocked.so if even i restart my sql server processes that again increase rollback process time.so let me know how to reslove this??? your help is really appreciate.thanks
hi everyone.i found solution in my case.i restart my production server so that process gone.everything is fine.but in any case if your rollback process being blocked then Kick everyone off the database, stop all jobs and wait for it to complete. thanks
Sometimes it may happen that your processes will hunge and to fix that you need to restart the server, but before restating the server I would recommend you to restart the services.
quote:Sometimes it may happen that your processes will hunge and to fix that you need to restart the server, but before restating the server I would recommend you to restart the services.
what??on a prod server you recommend of service bounce and reboots do read the post carefully before suggesting
problem to kill user process
Posted - 03/24/2008 : 16:25:42
