This morning one of my applications gone mad and filled up the transaction log file of my database. (230+ GB to be more precise) I am not a DBA, and not much used MSSQL before. So when I saw the log file there, i thought it must be the logs of what happened in the database in the past X amount of time. Of course to be back in business as soon as possible, I deleted this file! Mistake! DO NOT DELETE YOUR TRANSACTION LOG FILE! 😛 Well just in case you did the same thing, read this article. It is an excellent article to save your balls from a cold shower