Clearing transaction logs in SQL Server

Select Database
Open Query Writer
Execute following commands:

backup log <dbname> with truncate_only
go
DBCC SHRINKDATABASE ( <dbname>, 10, TRUNCATEONLY)
go