Corrupt syscolumn indexes - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Corrupt syscolumn indexes

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-31 : 07:57:05

Russ writes "On running dbcc checktable(syscolumns):

Server: Msg 2511, Level 16, State 1, Line 1
Table Corrupt: Object ID 3, Index ID 0. Keys out of order on page (1:5077962), slots 10 and 11.
Server: Msg 8933, Level 16, State 1, Line 1
Table Corrupt: Object ID 3, index ID 1. The low key value on page (1:4528534) (level 0) is not >= the key value in the parent (1:1991359) slot 31.
DBCC results for 'syscolumns'.
There are 104153 rows in 3069 pages for object 'syscolumns'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'syscolumns' (object ID 3).
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (OracleTest.dbo.syscolumns ).

DBCC checkdb returns:
Server: Msg 2511, Level 16, State 1, Line 1
Table Corrupt: Object ID 3, Index ID 0. Keys out of order on page (1:5077962), slots 10 and 11.
Server: Msg 8933, Level 16, State 1, Line 1
Table Corrupt: Object ID 3, index ID 1. The low key value on page (1:4528534) (level 0) is not >= the key value in the parent (1:1991359) slot 31.
DBCC results for 'syscolumns'.
There are 104153 rows in 3069 pages for object 'syscolumns'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'syscolumns' (object ID 3).
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (OracleTest.dbo.syscolumns ).

I have no idea what happened to this thing as I maintain the instance and not this particular database. The DBA for this one however doesn't seem to be very experienced and doesn't know what he did to cause this. The database is open and readable except for this error. I of course cannot use dbcc dbreindex as this is a system table. Is there anyway to drop and recreate system indexes? The DBA was screwing around with this last night and trashed it totally, I had a restore fortunately, but it is in this state. The version is 7.0 SP4

Any help would be great."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-31 : 11:39:50

Have you tried DBCC CHECKDB with the various fix options? If you have and it didn't fix it, then have you restored the database yet?

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources