Does backup of transaction log reduce the log file size or it is DBCC SHRINKFILE really make the size small?
I know it is not good practice to shrink log, but we have special case that need to do that to save space. For example we have some archived databases and set to readonly, and simple recovery mode,
we don't need those big log file there, so I was able to shrink the log size to a smaller one.
But I remember somewhere I read only backup transaction log reduces the size, not shrink , or maybe I didn't remmember it correctly?