Sql Server2014数据库清理日志

sql server2014数据库日志占用特别大，清理方法。直接贴代码

    use[master]
    go
    alter database db_name set recovery simple with no_wait
    go
    alter database db_name set recovery simple   --简单模式
    go
    use db_name 
    go
    dbcc shrinkfile (n'db_name_log' , 11, truncateonly)
    go
    use[master]
    go


    alter database db_name set recovery full with no_wait


    go


    alter database db_name set recovery full  --还原为完全模式


    go