清理SQL数据库日志

时间：2014-01-20 19:31:15 收藏：0 阅读：431

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

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