Forum Discussion

QueryRunsFast's avatar
QueryRunsFast
Copper Contributor
Nov 15, 2024

Cannot truncate logs full when transaction cannot rollback

Hello,

I recently experienced the problem when my database has a full transaction log but I can't truncate it via SSMS.

I had to pass commands manually in T-SQL, but since the log was full, a query in progress was killed and proceeded to a rollback.

However, the rollback was blocked at 0% because the logs were full, and the log files were locked because a transaction was in progress…

Is there any other way of getting out of this situation without restarting the instance? (I've tried a backup + log shrink, adding log files, changing the recovery model to Simple, etc. But nothing works)

  • yunusemre's avatar
    yunusemre
    Copper Contributor

    Hi, did you try to shrink log file after changing recovery model to simple? 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    select name, log_reuse_wait_desc
    from sys.databases

    Lot of words without usefull informations.

    What do the query return?

Resources