Re: Table Corrupt

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/27/04

  • Next message: Chris W: "Multiple Server query" 
    Date: Tue, 27 Apr 2004 09:25:08 +0530

    Hi,

    What is the version/edition of SQL Server you are using. Did you patched the
    SQL server with latest service pack?

    Did you tried the below steps:-

    1. Perform a complete backup of the database and kleep it in safe place
    2. Set the database to sincle user mode (Alter database <dbname> Single_user
    with rollback immediate)
    3 Ensure that TEMPDB have enough space, because DBCC CHECKDB uses tempdb
    4. Execute DBCC CHECKDB with REPAIR_REBUILD option

    Note:
    If the abobe steps fail then you need to restore from good backup or contact
    Microsoft Support.

    Look into the below article for the cause of this error:-
    http://support.microsoft.com/default.aspx?scid=kb;en-us;276992

    Thanks
    Hari
    MCDBA

    "Mary" <anonymous@discussions.microsoft.com> wrote in message
    news:05e601c42bb1$e553d9e0$3501280a@phx.gbl...
    > Hi All,
    >
    > Could someone please tell me how to fix the following
    > error? This error is appearing on several tables for 2
    > weeks now. I already ran a complete hardware diagnostics
    > on the server and it is cleaned. Please help, I am
    > getting desperate.
    >
    > Server: Msg 2535, Level 16, State 1, Line 0
    > Table Corrupt: Page (1:566656) is allocated to object ID
    > 1189579276, index ID 255, not to object ID 798625888,
    > index ID 5 found in page header.
    >
    > Thanks,
    >
    > Mary

  • Next message: Chris W: "Multiple Server query"

    Relevant Pages