MSSql 清理日志文件

SQL：

USE ${your_database}
GO
 
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE ${your_database}
  SET RECOVERY SIMPLE;
GO
 
-- Shrink the truncated log file to 22000 MB.
DBCC SHRINKFILE (N'your_database_log', 22000);
GO
 
-- Reset the database recovery model.
ALTER DATABASE ${your_database}
  SET RECOVERY FULL;
GO