How to truncate log file in SQL Server 2005

Found this nice article on how to truncate or totally eliminate log file in SQL Server 2005. I had to do this, because one of my websites’ log file got up 6Gig. The procedure is not recommended by Microsoft for live databases, but I could not afford to have it take up that much space. [...]

MS SQL Server Suspect Database

Ever had your database marked as ‘Suspect’? It happened to me today, and it’s easily fixed by restarting SQL Server.