Forum Discussion
QueryRunsFast
Nov 15, 2024Copper Contributor
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)
- yunusemreCopper Contributor
Hi, did you try to shrink log file after changing recovery model to simple?
- olafhelperBronze Contributor
select name, log_reuse_wait_desc from sys.databases
Lot of words without usefull informations.
What do the query return?