BizTalk: Database ‘BizTalkMsgBoxDb’ is full

Error:

The transaction log for database ‘BizTalkMsgBoxDb’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases (.Net SqlClient Data Provider)

 

Solution:

sp_helpdb ‘BizTalkMsgBoxDb’

ALTER DATABASE BiztalkMsgBoxDb

SET RECOVERY SIMPLE;

GO

DBCC SHRINKFILE (BiztalkMsgBoxDb_log, 1);

GO

sp_helpdb ‘BizTalkMsgBoxDb’

GO

ALTER DATABASE BiztalkMsgBoxDb

SET RECOVERY FULL

GO