Log files grow and unable to shrink even after backup.





  1. Launch MS SQL Server Mananagement Studio
  2. Execute SQL command > DBCC OPENTRAN
  3. You will get below result. You notice the SPID is 76


  4. Go > Management > Activity Monitor

  5. Now you find your SPID running

  6. Just right click and kill the SPID. It might take more then 1 hour before the process is killed/rollback