1.清空日志:DUMP TRANSACTION databasename WITH NO_LOG
2.截断事务日志:BACKUP LOG databasename WITH NO_LOG
3.收缩数据库:DBCC SHRINKDATABASE(databasename)
转载于:https://www.cnblogs.com/CandiceW/p/4465771.html
1.清空日志:DUMP TRANSACTION databasename WITH NO_LOG
2.截断事务日志:BACKUP LOG databasename WITH NO_LOG
3.收缩数据库:DBCC SHRINKDATABASE(databasename)
转载于:https://www.cnblogs.com/CandiceW/p/4465771.html