• Thanks Jeff. I also figured from different articles that it can be solved by service bounce. But problem is the bounce is scheduled for weekend and I have to move the log file of this DB to another drive by taking it offline. Can I safely take it offline and move file with the Killed/Rollback still there? It's not taking any CPU and estimated time is 0.

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.