Many times, it happens in live sql server which has big transaction log file, you run DBCC SHRINKFILE command and see no effect of it on the transaction log file. You can use following magical five line at that time and you will done. It shrinks the trucated log File to minimum size possible.
USE DBNameGODBCC SHRINKFILE(<logfilename>, 1)BACKUP LOG WITH TRUNCATE_ONLYDBCC SHRINKFILE(<logfilename>, 1)
We will go in depth study for internal working of transaction log soon in my future article. Happy Working!!!!
Reference: Ritesh Shah