BizTalk: Database ‘BizTalkMsgBoxDb’ is full
Posted on 2012-02-08 18:13 zhaobin 阅读(230) 评论(0) 编辑 收藏 举报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
