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
CCCC
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:
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:
> 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
>
>|||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...
> 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:
>> 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
>>|||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...
> > 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:
> >
> >> 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
> >>
> >>
> >>
>
>sql