What are the challenges you face when working across database platforms? Take the survey

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?




Sign In or Register to comment.