sql server truncate log script

 use ttt
 go
 sp_removedbreplication
    go
    alter database ttt set recovery simple
    go
    dbcc shrinkfile('ttt_log',200)
    go
    alter database ttt set recovery FUll
    go