Originally posted by : Alex (AlexLut@aol.com)Hello,I need to clear a log file in SQL Server 2000. I know that I can shrink and remove any unused space and etc. My problem is that a log file has a lot of old transactions and I would like to not only shrink the file but also clean it. Let's say my file right now is 20mb and I want to make it back to 2mb. Thank you in advance.