giovedì 12 gennaio 2012

BizTalk: Database ‘BizTalkDTADb’ is full


Error:
The transaction log for database ‘BizTalkDTADb’ 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 ‘BizTalkDTADb’
ALTER DATABASE BiztalkDTADb
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (BiztalkDTADb_log, 1);
GO
sp_helpdb ‘BizTalkDTADb’
GO
ALTER DATABASE BiztalkDTADb
SET RECOVERY FULL
GO

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