如何删除日志？

Posted on 2008-05-16 12:12 AmyQiu 阅读(815) 评论(1) 编辑收藏举报

清空日志
DUMP TRANSACTION   DataBaseName   WITH NO_LOG

截断事务日志
BACKUP LOG   DataBaseName   WITH NO_LOG

收缩数据库
DBCC SHRINKDATABASE(DataBaseName, {NOTRUNCATE | TRUNCATEONLY })

删除日志： DataBase->Properties->Files->Log->Initial Size