sqlserver2022
1 TopicFull 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.223Views0likes0Comments