CODE TSQL – Shrinking truncate log file

WARNING:This will break the logs and you will loose the ability to restore point in time. Be sure to run a full backup after you run this query