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