Competition: What’s your favorite Redgate tool? Enter now.

shrinking log after truncate inactive portion of log

colbycolby Posts: 30
edited May 19, 2008 12:53PM in SQL Backup Previous Versions
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

Comments

Sign In or Register to comment.