SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 problem to kill user process
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

saurabh811
Starting Member

USA
33 Posts

Posted - 03/24/2008 :  16:25:42  Show Profile  Reply with Quote
Hi
Having problem to kill user process.

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

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 03/24/2008 :  16:36:32  Show Profile  Reply with Quote
Try

DBCC inputbuffer(spidid) to find out what is going on or use activity monitor. IS that Spid Sysadmin? You can't kill sysadmin.
Go to Top of Page

saurabh811
Starting Member

USA
33 Posts

Posted - 03/24/2008 :  16:47:33  Show Profile  Reply with Quote
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.
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 03/24/2008 :  16:59:04  Show Profile  Reply with Quote
Just curious, Why you want to kill?
Go to Top of Page

saurabh811
Starting Member

USA
33 Posts

Posted - 03/24/2008 :  17:04:29  Show Profile  Reply with Quote
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.
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 03/24/2008 :  17:19:27  Show Profile  Reply with Quote
Can you show the script you used for backup?
Go to Top of Page

saurabh811
Starting Member

USA
33 Posts

Posted - 03/24/2008 :  17:31:34  Show Profile  Reply with Quote
why you want to see script???
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 03/24/2008 :  22:50:00  Show Profile  Reply with Quote
Because people try to help you. By the way, did you see any error in sql server log?
Go to Top of Page

saurabh811
Starting Member

USA
33 Posts

Posted - 03/25/2008 :  11:21:49  Show Profile  Reply with Quote
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
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 03/25/2008 :  11:25:50  Show Profile  Reply with Quote
Until and unless you post the what exactly you are using ,You won't get help here.
Go to Top of Page

saurabh811
Starting Member

USA
33 Posts

Posted - 03/25/2008 :  12:18:07  Show Profile  Reply with Quote
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


Go to Top of Page

mdubey
Posting Yak Master

USA
133 Posts

Posted - 05/27/2008 :  10:36:54  Show Profile  Reply with 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.

Manoj
MCP, MCTS
Go to Top of Page

monty
Posting Yak Master

130 Posts

Posted - 05/27/2008 :  12:43:46  Show Profile  Reply with Quote
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

its me monty
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000