Query to clear log

Replace emo by the Database name you want to clear the log

    dump transaction eMO with truncate_only  go

    declare @filename varchar(50)

    select @filename = file_name(2)

    dbcc shrinkfile (@filename, 10)

    go

    dbcc shrinkdatabase (eMO, truncateonly)

    go