Post reply

DB Consistency errors

  • July 27, 2009 at 11:11 pm

    #133511

    Hi,

    Couple of my production databases reported Consistency error

    (more than 800 errors per databases).

    CHECKALLOC reported 0 errors.

    I repaired them with allow_data_loss as this was the minimum DBCC repair level.

    My DBs are fine now but I want to check when exactly those consistency errors started coming in and then to find out the root cause.

    I am exploring everything so far and so how looking out for similar expertise from you guys. Thanks

    VS

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • July 27, 2009 at 11:42 pm

    #1030838

    can you post the sample error message....

    Rajesh Kasturi

  • July 27, 2009 at 11:59 pm

    #1030845

    Duplicate post. Please post your replies at http://www.sqlservercentral.com/Forums/Topic760489-146-1.aspx

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • July 28, 2009 at 12:02 am

    #1030847

    duplicate post was because of site strange behaviour. Gail can you delete one of it...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • July 28, 2009 at 1:09 am

    #1030874

    Vishal Singh (7/28/2009)

    Gail can you delete one of it...

    I'm not a moderator. Only Steve can delete threads 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

  • July 28, 2009 at 3:37 am

    #1030919

    Ohk..I thought you are a moderator...thanx for the info.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 6 posts - 1 through 5 (of 5 total)

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