Results 1 to 2 of 2

Thread: Corrupt indexes

  1. #1
    Join Date
    Sep 2005
    Posts
    9

    Unanswered: Corrupt indexes

    Hi

    I have a table that keeps getting corrupt all the time. If I do a dbcc checktable, it says the primary key is corrupt. I can fix this by dropping the PK and creating it again, then the table is fine for a while. Problem is, this keeps happening every week! It's quite a big table (15.8 mil records), so this is timeconsuming to drop and recreate PK...

    When trying to query the table, it returns the following error:
    Attempt to fetch logical page (1:680898) in database 'dbCustomer' belongs to object 'tblPlayer', not to object 'tblTransactions'.
    tblTransactions is the table that gets currupt.
    The logical page number is different every time as well, so it's not the page it self causing the problem.

    The table is updated via transactional replication. The source is in Cape Town, South Africa and the destination in Canada, North America. We do have many other tables being replicated in this manner for many years, but none have given this problem before.

    Does anyone have some advice as to what I need to look at maybe? I'm not really sure where to start looking for the cause of the problem.

    Thanks,
    TeaaZA

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    You don't mention specifics, so let's start there. What operating system? What database engine (SQL Server, Oracle,etc.)? What version. What service pack? What type of data storage system, version, patches? If this is Windows, have you looked at the system event logs? If this is SQL Server, have you looked at the error logs? have you checked Microsoft KnowledgeBase for any errors that you found?

    Even without all that, in my experience this type of problem is usually associated with hardware, usually the disk or controller or cache. Note the word ** usually **. Your circumstances may vary. You need more information. Right now your question is to ambiguous to answer.

    How high is up? My car won't start, why? What is behind the recent problems with dbForums?

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •