shrinking log after truncate inactive portion of log

colby

One of the mapped drives ran out of disk space and was forced to manualy truncate log and did a dbcc shrinkfile on the log file to recover many GB of disk space. Then did a full backup of DB so the backup of transactional logs would not err.

Question: Is there an option to recover the disk space from running the backup of transaction logs? I see the option to truncate the inactive portion of the log but not to recover the disk space. If not then any workarounds?

Thanks

Colby

Brian Donahue

Hello,

SQL Backup does not automatically shrink any log files for you -- to my knowledge no backup product does this. But this is a question that comes up frequently, so the answer is in our knowledge base.