Post reply

Database Is Set to Suspect

  • February 21, 2009 at 12:36 am

    #200508

    Hi,

    I have executed the DBCC Checkdb() and found that the database is mared as suspect,How can i reslove this issue?

    can we reslove the issue by sp_resetstatus "Dbname" altering the database in single user mode

  • February 21, 2009 at 2:58 am

    #948130

    y.koteswarrao (2/21/2009)

    I have executed the DBCC Checkdb() and found that the database is mared as suspect,How can i reslove this issue?

    Depends why it's suspect.

    Please post the full output of checkdb (if it will run) and any errors in the SQL error log that relate to this database.

    can we reslove the issue by sp_resetstatus "Dbname" altering the database in single user mode

    That's a SQL 2000 fix. Not for SQL 2005.

    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

  • February 24, 2009 at 7:26 am

    #949344

    Before doing anything try checking what could have caused this to be like this before fixing so that after fixing the db then the next step should be preventing the problem. As GM has said try to post error messages as well this could be of gr8 help

    What you don't know won't hurt you but what you know will make you plan to know better

  • March 3, 2009 at 2:21 am

    #952265

    You can find some valuable advice here:

    http://sqlskills.com/BLOGS/PAUL/category/CHECKDB-From-Every-Angle.aspx

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

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