Forum Discussion

filipemilhomem's avatar
filipemilhomem
Copper Contributor
Sep 04, 2024

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

Resources