--先查询数据库日志文件名
USE [Test]
GO
SELECT name FROM SYS.database_files WHERE type_desc='LOG'
--数据库日志文件压缩
USE [master]
GO
ALTER DATABASE [Test] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Test] SET RECOVERY SIMPLE
GO
USE [Test]
GO
DBCC SHRINKFILE (N'Test_log' , 0,TRUNCATEONLY) --这里就填入数据库的日志文件名
GO
USE [master]
GO
ALTER DATABASE [Test] SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE [Test] SET RECOVERY FULL