详细资料

SQLServer数据库清空ldf日志文件

USE [master]

ALTER DATABASE [DB_Develop]

SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE [DB_Develop]

SET RECOVERY SIMPLE

GO

USE [DB_Develop]

DECLARE @logname VARCHAR(150)

SELECT @logname = NAME

FROM sys.database_files

WHERE NAME LIKE'%log'

DBCC SHRINKFILE(@logname, 11, TRUNCATEONLY)

GO

USE [master]

ALTER DATABASE [DB_Develop]

SET RECOVERY FULL WITH NO_WAIT

ALTER DATABASE [DB_Develop]

SET RECOVERY FULL

GO

文章来源：https://www.cnblogs.com/88223100/p/How_to_clearn_sql_server-ldf_file.html