Post reply

error 2750 and so on

  • August 5, 2011 at 5:29 am

    #245743

    Hi all

    i had corrupted table on server, DBCC CHECKTABLE returns me error 2570 (followed by 2511, 8984 and 8988, because corupted table is partitioned and column is part of primary key). i know it was discussed here sometimes and it hellped me to solve this problem, thx for previous posts.

    but i want to ask you what could be a reason of this error? I tryied to find any information in logs and i did found nothing 🙁 Errorlog file onlly contains information about this error but there is not any suspected mesage before. windows event log nor cluster log did not contain any important information (or im "blind").

    please, can anybody help me what i should to find or what is most offten reason of this error.

    thanks

  • August 5, 2011 at 5:38 am

    #1364242

    Corruption is almost always caused by a problem in the IO subsystem. Could be anything in the IO stack.

    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

  • August 5, 2011 at 6:44 am

    #1364302

    if you're running on a server go into the server diags and check for hardware warnings/errors in the server logs. Open Manage for DELL and HP Server Management on HP servers.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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