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.
| Author |
Topic |
|
Chester
Starting Member
27 Posts |
 Posted - 2004-10-04 : 10:22:43
|
| We are running SQL2000 and encountered over 7000 errors, similarto those below, when running CHECKDB.DBCC results for 'sysindexes'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 2: Errors found in text ID 196608 owned by data record identified by RID = (1:24:1) id = 1 and indid = 2.Server: Msg 8929, Level 16, State 1, Line 1Object ID 2: Errors found in text ID 262144 owned by data record identified by RID = (1:24:2) id = 1 and indid = 3.Server: Msg 8929, Level 16, State 1, Line 1Object ID 2: Errors found in text ID 12517376 owned by data record identified by RID = (1:24:3) id = 2 and indid = 1.Is there a way to fix the sysindexes table without doing a restore?Would trying to run DBCC DBREINDEX('sysindexes') help?TIA. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-04 : 13:43:54
|
| DBCC DBREINDEX probably will not help although explicitly dropping and recreating the indexes might. Have you tried the repair options available with DBCC CHECKDB? The repair options are documented in SQL Server Books Online under DBCC CHECKDB topic.Tara |
 |
|
|
Chester
Starting Member
27 Posts |
Posted - 2004-10-04 : 13:54:01
|
| Yeah, we tried the repair options but they did not work.What appears to have worked though is explicitly dropping and recreatingthe indexes.Thanks. |
|
|
|
|
|
|
Sysindex table problems