Rollback Termination | SQL Server Performance Forums

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 Riya

from BOL
If the rollback of the spid or UOW has completed when the KILL command with the WITH STATUSONLY option is executed —————————————-
Cast your vote

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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.