Forum Discussion
filipemilhomem
Sep 04, 2024Copper Contributor
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.
No RepliesBe the first to reply