sysindex corrption

  • one of the database of my PRD server is currpted(problem with sysindex)

    what i need to do ?

    Regards,
    Shivrudra W

  • shivrudra_2008 (11/27/2009)


    one of the database of my PRD server is currpted(problem with sysindex)

    what i need to do ?

    Post the error that you have seen.

    I am assuming that you have already run DBCC CHECKDB, can you post the results.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • hi,

    i dont have error now but i will explain you wht is the issue.

    there is consistancy problem with sysindexes

    database is up and running but my regular maintanance plan going fail with objects inconsistancy.

    Regards,
    Shivrudra W

  • Please run the following and post the FULL output. There's not enough information in what you've so far posted to make even an educated guess.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    First thing I have to ask. Do you have a clean backup of this database (a backup that doesn't have the corruption)?

    p.s. This is not a security question and, since you mention sysindexes, I'm guessing it's SQL 2000. Please can you post in the appropriate forum in the future. Thanks

    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 4 posts - 1 through 3 (of 3 total)

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