One of our customer can't truncate logs, the following is the issue:
The logs are HUGE – Apparently, and I didn’t realize this, the backup software will easily backup the DB’s, but doesn’t touch the transaction logs. One was 18.5 GB and the other was almost 26 GB. I did a SQL backup of them last night, and I’m attempting to truncate them, but receiving
“Cannot shrink log file 2 (Consumer_log) because of minimum log space required.