删除SQL数据库中事务日志方法
发布时间：2015-06-05 来源：查字典编辑
摘要：DUMPTRANSACTION[数据库名]WITHNO_LOGBACKUPLOG[数据库名]WITHNO_LOGDBCCSHRINKDATA...
DUMP TRANSACTION [数据库名] WITH NO_LOG
BACKUP LOG [数据库名] WITH NO_LOG
DBCC SHRINKDATABASE([数据库名])
DUMP TRANSACTION [数据库名] WITH NO_LOG
BACKUP LOG [数据库名] WITH NO_LOG
DBCC SHRINKDATABASE([数据库名])