SQL Server 数据库日志压缩脚本

USE File_DB;

SELECT * FROM sys.database_files;

GO

-- Truncate the log by changing the database recovery model to SIMPLE.

--修改数据库恢复模式

ALTER DATABASE File_DB SET RECOVERY SIMPLE;

GO

-- Shrink the trun cated log file to 10 MB.

--收缩日志至10MB

DBCC SHRINKFILE (File_DB_log, 10);

GO

-- Reset the database recovery model.

--修改数据库恢复模式

ALTER DATABASE File_DB SET RECOVERY FULL;

GO