you can also take the help of this link: http://stackoverflow.com/questions/56628/how-do-you-clear-the-sql-server-transaction-log