How do I flush old sql process
Hi,
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.
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.
MacNuttin
Be careful this might be EMC NetWorker Module for Microsoft SQL Server provides fast online backup and restore for Microsoft® SQL Server databases, ensuring availability of mission-critical application data.
ASKER
Hi MacNuttin
What u mean here??? is that mean I have to let the process disappear by them self?
What u mean here??? is that mean I have to let the process disappear by them self?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.