How do I flush old sql process
Posted on 2006-11-11
I'd killed sql process for backup
Kill 55 and its showing me the rollback completed as below:
SPID 55: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds.
however when I executing the backup job again, the new backup get block by above process where spid55 is the blocker.
I run the sp_who2 and guve me results in sql process, why this process id not disappear in my sql server and how do I get this clear from there?
55 RUNNABLE NT AUTHORITY\SYSTEM ETRTXC . TestReports KILLED/ROLLBACK 528469 5864087 11/10 20:38:58 NetWorker Module for Microsoft (R) SQL Server 55
and dbcc opentran still showing me this above process is active
Transaction information for database 'ETRTXC'.
Oldest active transaction:
SPID (server process ID) : 55
UID (user ID) : 1
Name : ClearChangeBits
LSN : (2418071:490082:1)
Start time : Nov 10 2006 8:38:58:453PM
DBCC execution completed. If DBCC printed error messages, contact your system administrator.