sql2008日志文件截断

日志文件比较大时,使用语句减少大小。

USE DATABASENAME;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE DATABASENAME
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (DATABASENAME_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE DATABASENAME
SET RECOVERY FULL;
GO

sql2008日志文件截断,布布扣,bubuko.com

sql2008日志文件截断

上一篇:mysql技巧总结


下一篇:uva - 10905 - Children's Game(贪心,qsort排序)