MSSQL2008 日志文件收缩
SQL2008清理日志文件:
查询分析器执行:
backup log TestDataBase to disk='F:\hooyesRoot\TestDataBase_log20090518.bak'
dbcc shrinkfile('TestDataBase ',200) with no_infomsgs
dbcc shrinkfile('TestDataBase ',200) with no_infomsgs
执行以上语句,将数据 Testdatabase 日志备份到 F 盘
并收缩日志文件为 200 M
更多详情:
http://support.microsoft.com/default.aspx/kb/907511/zh-cn?spid=2855&sid=1064
by