MS SQL 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)

发表评论

电子邮件地址不会被公开。

This site uses Akismet to reduce spam. Learn how your comment data is processed.