导航

04 2011 档案

摘要:http://www.cnblogs.com/webabcd/archive/2010/06/03/1750449.html 阅读全文

posted @ 2011-04-15 12:17 kingwangzhen 阅读(171) 评论(0) 推荐(0)

摘要:http://www.cnblogs.com/webabcd/archive/2007/02/04/639830.html 阅读全文

posted @ 2011-04-15 12:15 kingwangzhen 阅读(124) 评论(0) 推荐(0)

摘要:在SQL SERVER 2008 中 BACKUP LOG WITH TRUNCATE_ONLY 已不再被支持,要收缩数据库日志,首先需要通过将数据库恢复模式设置为 SIMPLE 来截断该文件。语句如下:CodeCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->USEDATABASENAME;GO--TruncatethelogbychangingthedatabaserecoverymodeltoSIMPLE.ALTERDATABASEDAT 阅读全文

posted @ 2011-04-02 13:06 kingwangzhen 阅读(250) 评论(0) 推荐(0)