RE: Help! My SQL Server Log File is too big!!!
Thanks Tim, you saved my life. My 1Gb+ database file had a 228Gb log file on a 230Gb hard drive, I was down to my last 10Mb!! 5 minutes after reading your excellent article I had a 103Mb log file. Thank you for explaining everything so clearly. I was able to discover that my issue was down to replication. After I removed replication with the sp_removedbreplication command the SHRINKFILE command worked perfectly.
Keep Up with TechRepublic