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)
Full Transaction Log disk
Hello all, I have two databases and problems with the transaction disk growing up too much and getting don't less. Using the query: select name, recovery_model_desc, log_reuse_wait_desc from sys.databases I can see both databases have the Recovery Model set to FULL. The files .ldf get values too high. How can I change the default configuration to NEVER have problems with the full disk? Because once the disk is full the web application can't do more transactions/requests queries. Thank you.