Author |
Topic |
saurabh811
Starting Member
33 Posts |
Posted - 2008-03-24 : 16:25:42
|
HiHaving problem to kill user process.OS: windows server 2003database version: sql server 2005i want to kill user process.when i tried to kill user process using its spid... kill 57i 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 BACKUPTHREADone 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 luckis 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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-24 : 16:36:32
|
Try DBCC inputbuffer(spidid) to find out what is going on or use activity monitor. IS that Spid Sysadmin? You can't kill sysadmin. |
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2008-03-24 : 16:47:33
|
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. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-24 : 16:59:04
|
Just curious, Why you want to kill? |
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2008-03-24 : 17:04:29
|
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. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-24 : 17:19:27
|
Can you show the script you used for backup? |
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2008-03-24 : 17:31:34
|
why you want to see script??? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 22:50:00
|
Because people try to help you. By the way, did you see any error in sql server log? |
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2008-03-25 : 11:21:49
|
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 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-25 : 11:25:50
|
Until and unless you post the what exactly you are using ,You won't get help here. |
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2008-03-25 : 12:18:07
|
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 |
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-27 : 10:36:54
|
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.ManojMCP, MCTS |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2008-05-27 : 12:43:46
|
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 suggestingits me monty |
|
|
|