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
 BACKUP LOG databasename WITH NO_LOG
 DBCC SHRINKDATABASE(databasename)



coded by nessus
发表评论?

0 条评论。

发表评论