Kill session

I've made a kill to a session that is stucked in SQL Server 2000 Enterprise +
SP3 with the status KILLED/ROLLBACK.
How can i force the kill ?
SQL> kill 567
SPID 567: transaction rollback in progress. Estimated rollback completion:
100%. Estimated time remaining: 0 seconds.
Thanks in advance
CC
CC
Take your coffee , it takes time
"CC" <CC@.discussions.microsoft.com> wrote in message
news:CB29FBB8-0772-4315-9DAB-3D898D39C354@.microsoft.com...
> I've made a kill to a session that is stucked in SQL Server 2000
> Enterprise +
> SP3 with the status KILLED/ROLLBACK.
> How can i force the kill ?
> SQL> kill 567
> SPID 567: transaction rollback in progress. Estimated rollback completion:
> 100%. Estimated time remaining: 0 seconds.
> Thanks in advance
> CC
|||Thanks Uri but:
-Estimated time remaining: 0 seconds
-Estimated rollback completion:100%
-Spid last_batch in sysprocesses 2005-09-12 00:52:15.380 (7 Days)
This session is from a backup:
sp_lock:
5671400DB[BULK-OP-LOG] XGRANT
5671400DB[BULK-OP-DB] XGRANT
5671400DB SGRANT
My full database backup don't start because of this session and i do not
want to restart SQL Server service on a production database because of a
zombie spid.
I think i will need more than a coffe : ) Can you help ?
The spid was killed but does not release locks held.
CC
"Uri Dimant" wrote:

> CC
> Take your coffee , it takes time
>
> "CC" <CC@.discussions.microsoft.com> wrote in message
> news:CB29FBB8-0772-4315-9DAB-3D898D39C354@.microsoft.com...
>
>
|||CC
Well, one option is to restart MS Service , another is if the first one does
not help ,in Task Manager to kill the process.
"CC" <CC@.discussions.microsoft.com> wrote in message
news:131B1221-349A-4260-93F9-2FF6BAF63BBD@.microsoft.com...[vbcol=seagreen]
> Thanks Uri but:
> -Estimated time remaining: 0 seconds
> -Estimated rollback completion:100%
> -Spid last_batch in sysprocesses 2005-09-12 00:52:15.380 (7 Days)
> This session is from a backup:
> sp_lock:
> 567 14 0 0 DB [BULK-OP-LOG] X GRANT
> 567 14 0 0 DB [BULK-OP-DB] X GRANT
> 567 14 0 0 DB S GRANT
> My full database backup don't start because of this session and i do not
> want to restart SQL Server service on a production database because of a
> zombie spid.
> I think i will need more than a coffe : ) Can you help ?
> The spid was killed but does not release locks held.
> CC
> "Uri Dimant" wrote:
|||So is BULK-OP-DB and BULK-OP-LOG used for any file growth operations? I see
it holding locks on backups?
"Uri Dimant" wrote:

> CC
> Well, one option is to restart MS Service , another is if the first one does
> not help ,in Task Manager to kill the process.
>
>
> "CC" <CC@.discussions.microsoft.com> wrote in message
> news:131B1221-349A-4260-93F9-2FF6BAF63BBD@.microsoft.com...
>
>