标签存档: 清空

mssql server 清空事务日志

1.清空日志:DUMP   TRANSACTION   databasename   WITH   NO_LOG
2.截断事务日志:BACKUP   LOG   databasename   WITH   NO_LOG
3.收缩数据库:DBCC   SHRINKDATABASE(databasename)
DUMP TRANSACTION databasename WITH NO_LOG
阅读全文——共233字