Help-Corrupt table
From: VanColeJones (anonymous_at_discussions.microsoft.com)
Date: 02/22/05
- Next message: Paul S Randal [MS]: "Re: Help-Corrupt table"
- Previous message: Andrew J. Kelly: "Re: Fragmentation Issues and Long Index Defragmentation Times."
- In reply to: VanColeJones: "Help-Corrupt table"
- Next in thread: Van Jones: "Help-Corrupt table"
- Reply: Van Jones: "Help-Corrupt table"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 22 Feb 2005 11:05:41 -0800
Thanks, that was it. Had to get the hotfix and test it
and all, but that was the problem.
Thanks,
Van
>-----Original Message-----
>I see a hypothetical index on the corrupt table
>named "ĸ8". It's not really a lower case "k". It's
>something else and the square is somekind a carrage
return
>or something because there is a blank line between this
>index name and the next. This index is listed as a
>clustered, hypothetical index. I already have a
clustered
>index on this table (different fields). Not sure if a
>clustered hypothetical index is valid. And the name? I
>tried to drop it. Said it didn't exist but left the
>square out of the name (like it didn't see the square
when
>it tried to drop it. So I u used brackets to refference
>it, and it says it's still not there (with the square
this
>time).
>
>>-----Original Message-----
>>In that case no - sorry, you will need to restore from
>>backup.
>>
>>If you still have access to your Databases Data then you
>>could re-create it using the generate SQL (but that
might
>>not work as it looks at the tables that caused the
>error),
>>DTS it, delete the old one, then rename the new one.
>>
>>BTW CHECKTABLE and CHECKDB are different if you check
BOL
>>under DBCC CHECKDB you will see 'DBCC CHECKDB performs
>the
>>same checking as if both a DBCC CHECKALLOC statement and
>a
>>DBCC CHECKTABLE statement were executed for each table
in
>>the database.'
>>
>>Anyway sorry I can't be of more help.
>>Peter
>>
>>"Age is an issue of mind over matter. If you don't mind,
>>it doesn't matter."
>>Mark Twain
>>
>>
>>>-----Original Message-----
>>>Yes. DBCC CheckTable is basically the same thing
except
>>>it only does one table. DBCC CheckDB generated the
same
>>>error.
>>>
>>>>-----Original Message-----
>>>>Have you tried a DBCC CHECKDB ?
>>>>
>>>>Peter
>>>>
>>>>"The length of this document defends it well against
>the
>>>>risk of its being read."
>>>>Winston Churchill
>>>>
>>>>
>>>>>-----Original Message-----
>>>>>I have a table that got corrupted last night
somehow.
>>>>>dbcc checktable on the table returns:
>>>>>
>>>>>Server: Msg 7995, Level 16, State 3, Line 1
>>>>>Database 'MPF' consistency errors in sysobjects,
>>>>>sysindexes, syscolumns, or systypes prevent further
>>>CHECK
>>>>>processing.
>>>>>DBCC execution completed. If DBCC printed error
>>>messages,
>>>>>contact your system administrator.
>>>>>
>>>>>I've tried all 3 options including
>>>REPAIR_ALLOW_DATA_LOSS
>>>>>and they all get the same results (above). I can't
>>>>select
>>>>>from the table either. I backed up the db and
>restored
>>>>it
>>>>>to another server...same thing. What all are my
>>options
>>>>>at this point? Is there anyway to fix the table
>>without
>>>>>going to backup?
>>>>>
>>>>>Thanks,
>>>>>
>>>>>Van
>>>>>.
>>>>>
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
- Next message: Paul S Randal [MS]: "Re: Help-Corrupt table"
- Previous message: Andrew J. Kelly: "Re: Fragmentation Issues and Long Index Defragmentation Times."
- In reply to: VanColeJones: "Help-Corrupt table"
- Next in thread: Van Jones: "Help-Corrupt table"
- Reply: Van Jones: "Help-Corrupt table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
