I need to shrink the physical size of some SQL transaction log files. Something happened where they grew to 4+ GB in size. The logs have 50mb used space after they were truncated. I’ve tried using DBCC SHRINKFILE, but it didn’t seem to do anything. I know I can re-create new devices, DB and everything else, but was wondering if there is a faster/easier way.
