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