locked
BizTalkMgmtDB marked as suspect RRS feed

  • Question

  • Have a VPC running Biztalk server 2010 and SQL 2008 R2.  Suddenly the VPC restarted and after startup, I couldnt login to BizTalk Admin console. Everything worked fine prior to this. When I login to the SQL Server Mgmt Studio, I see that BizTalkMgmtDb is marked as suspect.  Has anyone faced anything similar to this and can provide inputs. This needs resolved ASAP.

    Thanks a lot !

    Tuesday, January 4, 2011 7:54 PM

Answers

  • Hi,

     

    Try the following steps : 

    EXEC sp_resetstatus 'DBName'
    GO

    ALTER DATABASE DBName SET EMERGENCY
    DBCC checkdb('DBname')
    ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    DBCC CheckDB ('DBName', REPAIR_ALLOW_DATA_LOSS)
    ALTER DATABASE DBName SET MULTI_USER
    Go

    Hope it helps.

    Regards


    Tarik
    Friday, January 7, 2011 4:04 PM
  • Thank you Tariq and Steef. Tariq, I saw your post late. I reconfigured it to have it working, Thanks for your responses.
    Friday, January 7, 2011 4:41 PM

All replies