Good day everyone. I have an issue today where I ran out of space on the disk partition that holds the databases and log files. I noticed that most log files are very large. My largest one is nearly 7 GB.
I run log backups twice a day, differential backup nightly, and full backup over the weekend on these databases using Backup Exec 12.5. Any idea why they are so large still and how can I get them to shrink?
I noticed that the log_reuse_wait for most DBs in the sys.databases shows as being LOG_BACKUP. What can i do to resolve this issue?