- Launch MS SQL Server Mananagement Studio
- Execute SQL command > DBCC OPENTRAN
- You will get below result. You notice the SPID is 76
- Go > Management > Activity Monitor
- Now you find your SPID running
- Just right click and kill the SPID. It might take more then 1 hour before the process is killed/rollback
Log files grow and unable to shrink even after backup.