I recently setup transaction log backups after we had a log file get near its capacity.
I noticed after log files are truncated, they still use up the same amount of disk space.
Is it safe to shrink a log file? If so how do you determine what is an appropriate size to shrink it to?
I ask this because some databases, like a sharepoint content database, have log files that are 130 GB in size when their data files are only 5 GB. I assume that now that I am running hourly log backups they dont need logg files that huge.
-Edit - Also most of the logg files are setup with the default settings
View Complete Post