清除,收縮或截斷資料庫日志

DBCC SHRINKFILE (@LogicalFileName, @NewSize)

再是

BACKUP LOG dbname WITH TRUNCATE_ONLY

或者，先設定資料庫為簡單恢複模式，再收縮檔案，然後再設定資料庫為完整恢複模式。（要是資料庫原來就是簡單恢複模式，就直接收縮檔案即可）

e.g:

USE AdventureWorks;

GO

-- Truncate the log by changing the database recovery model to SIMPLE.

ALTER DATABASE AdventureWorks

SET RECOVERY SIMPLE;

-- Shrink the truncated log file to 1 MB.

DBCC SHRINKFILE (AdventureWorks_Log, 1);

-- Reset the database recovery model.

SET RECOVERY FULL;

要是截斷日志，可以這樣：

BACKUP LOG dbname WITH NO_LOG

Dbcc Shrinkdatabase('dbname')