Truncating Log Files and Recovering Space in Microsoft SQL Server 2005
A common issue for users of SQL Server databases is disk space and the size of the physical log file and database. While we're not going to attempt to make "one size fits all" statement on database maintenance plans, we though it would be helpful to provide a few suggestions that will help you trim the size of your files when you are in a pinch.
For more details click here
you can click on the following link