Post reply

What is the cause for Database goes to SUSPECT MODE

  • July 2, 2010 at 9:53 am

    #222796

    Hi Friends

    help me out ,what are the reasons for database gone into SUSPECT MODE and give me the solution to bring database back into use

    Thanks

    Kushi:-P

  • July 2, 2010 at 9:57 am

    #1188318

    Here is a link to an article that may help you.

    http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • July 2, 2010 at 10:38 am

    #1188348

    Is this an academic question, or do you have a suspect database?

    If you have a suspect database, do you have a backup?

    If you query sys.databases, what's the exact value for state_desc for the database in question?

    Check the SQL error log. There will be entries in there that give the reasons why SQL is marking the database suspect. Find them and post them here.

    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

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

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