【MS-SQL】The transaction log for database 'DatabaseName' is full due to 'LOG_BACKUP'

The transaction log for database 'DatabaseName' is full due to 'LOG_BACKUP'

交易紀錄爆炸，shrink 或增加上限。

Shrink

USE <DatabaseName>;  
GO  
-- Truncate the log by changing the database recovery model to SIMPLE.  
ALTER DATABASE <DatabaseName>  
SET RECOVERY SIMPLE;  
GO  
-- Shrink the truncated log file to 1 MB.  
DBCC SHRINKFILE (<DatabaseName>_Log, 1);  
GO  
-- Reset the database recovery model.  
ALTER DATABASE <DatabaseName>
SET RECOVERY FULL;  
GO 

上限