Friday, November 18, 2011

BizTalkMgmtDB marked as suspect

today I found that one of our BizTalk Servers are creating problems when access upon investigation I found that BiztalkTalkMdmtDb is in suspect status. to resolve this issue I did following things which are mentioned over the internet.

 

EXEC sp_resetstatus 'BizTalkMgmtDb'
ALTER DATABASE BizTalkMgmtDb SET EMERGENCY
DBCC checkdb(' BizTalkMgmtDb ')
ALTER DATABASE BizTalkMgmtDb SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('BizTalkMgmtDb', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE BizTalkMgmtDb SET MULTI_USER

Source

No comments: