I was having trouble with a transaction log file that had unrestricted growth set. I needed to get it down to a good size without killing my disk space. So below is the script I used to shrink the transaction log after it had gone a little wild with size.
log 'yourdatabasename' to disk ='D:\YourdatabaseName.trn'
If you liked this post, please be sure to subscribe to my RSS Feed.