USE DBNAME --数据库名
ALTER DATABASE DBNAME SET RECOVERY SIMPLE WITH NO_WAIT --TechMisDB为要清理的数据库名
GO
ALTER DATABASE DBNAME SET RECOVERY SIMPLE --简单模式
GO
DBCC SHRINKFILE (N'DBNAME_log' , 11, TRUNCATEONLY)--用上面有Select查看到的日志的文件名
GO
ALTER DATABASE DBNAME SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE DBNAME SET RECOVERY FULL --还原为完全模式
GO