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