sqlserver 日志文件太大压缩

 今天碰到个盈通的软件日志文件达百个G，

 
USE [master]
GO
ALTER DATABASE YTT6YYPRO_01 SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE YTT6YYPRO_01 SET RECOVERY SIMPLE
GO
USE YTT6YYPRO_01
GO
DBCC SHRINKFILE (N'YTSOFT_T6SY_log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE YTT6YYPRO_01 SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE YTT6YYPRO_01 SET RECOVERY FULL
GO
 

如果找不到YTSOFT_T6SY_log文件用以下语句查询 
USE DBName
 
GO
 
SELECT file_id, name FROM sys.database_files;
 
GO