清空sql server数据库日志

    USE [master]  
    GO  
    ALTER DATABASE WSS_Content_www SET RECOVERY SIMPLE WITH NO_WAIT  
    GO  
    ALTER DATABASE WSS_Content_www SET RECOVERY SIMPLE   --简单模式  
    GO  
    USE WSS_Content_www   
    GO  
    DBCC SHRINKFILE (N'WSS_Content_www_Log' , 11, TRUNCATEONLY)  
    GO  
    USE [master]  
    GO  
    ALTER DATABASE WSS_Content_www SET RECOVERY FULL WITH NO_WAIT  
    GO  
    ALTER DATABASE WSS_Content_www SET RECOVERY FULL  --还原为完全模式  
    GO