今天碰到个盈通的软件日志文件达百个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