清理SQL数据库日志

Use DB
Select NAME,size From sys.database_files
ALTER DATABASE DB SET RECOVERY SIMPLE WITH NO_WAIT ALTER DATABASE DB SET RECOVERY SIMPLE USE DB
DBCC SHRINKFILE(DB_log ,0,TRUNCATEONLY)
ALTER DATABASE DB SET RECOVERY FULL WITH NO_WAIT ALTER DATABASE DB SET RECOVERY FULL

清理SQL数据库日志

原文：http://www.cnblogs.com/liuyudun/p/3526695.html