Post reply

msdb marked suspect error 3313

  • July 7, 2014 at 1:20 pm

    #147035

    Can someone offer advice on how to bring up msdb ,marked suspect?

    the server was rebooted and this might have caused the problem.

    sql server detected a logical consistency-based error.

  • July 7, 2014 at 2:40 pm

    #1727576

    Restore from backup. then check your IO subsystem for problems.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 7, 2014 at 4:55 pm

    #1727613

    at this place we use BMC sqlbacktrack console.

    I restored a few hours ago, but it does not bring it online. I think on SSMS it says recovering...

    I cannot log into the box now and am taking vacation, so the regular DBA will take over, but thanks for your help.

    I've done a goodamount of SQL Server DBA supportsince 2003, but not much in the last 2 years.

    A little rusty.

    Steve

  • July 11, 2014 at 2:23 pm

    #1728890

    Short of restoring from a known good backup you could try:

    http://technet.microsoft.com/en-us/library/ff713991(v=sql.105).aspx

    even though these steps are for SQL Server 2008 and are reallly meant for application databases as opposed to system databases.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply