Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saurabh811
Starting Member
33 Posts |
 Posted - 2008-03-24 : 16:26:30
|
| 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:37:17
|
| Duplicate Post:Please lock it. |
 |
|
|
|
|
|
problem to kill user process