SQL Server Performance Forum – Threads Archive
Rollback Termination
Hi, A background process was terminated by running kill process. But soon it was noticed that the process started rollback. It is showing rollback status 0% for the past 30 minutes. Is there any way to terminate this rollback process. I feel restarting SQL may cause the database to go into recovery mode. Please suggest me, if there is a way to terminate this rollback.It is urgent, since it is a live issue. Thanks Regards Riyafrom BOL
quote:
If the rollback of the spid or UOW has completed when the KILL command with the WITH STATUSONLY option is executed
If the rollback of the spid or UOW has completed when the KILL command with the WITH STATUSONLY option is executed
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_kf-kz_1zos.asp —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
Let the rollback complete the transaction, otherwise you may lose the database due to inconsistency of process the transaction. If you can afford downtime then the only way is to ensure good backup is available and then restart the SQL services. And next time ensure to test that query or process on test bed to avoid any of these interruptions. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>