sql 清理日志

SELECT name

FROM SYS.database_files

WHERE type_desc = 'LOG'

--step 2 : 修改数据库恢复模式为简单模式

ALTER DATABASE [dbname] SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE [dbname] SET RECOVERY SIMPLE

--step 3 : 清除日志文件

DBCC SHRINKFILE ('dbname_Log' , 0,TRUNCATEONLY)

--step 4 : 还原数据库恢复模式为完整模式

ALTER DATABASE [dbname] SET RECOVERY FULL WITH NO_WAIT

ALTER DATABASE [dbname] SET RECOVERY FULL