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 |
|
greegy08
Starting Member
19 Posts |
 Posted - 2009-07-04 : 01:07:22
|
| when i try to run DBCC CHECKDB and i get this error> im using sql 2000-sp4Server: Msg 7995, Level 16, State 1, Line 1Database '522' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing.DBCC execution completed. If DBCC printed error messages, contact your system administrator.any help? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-04 : 04:10:34
|
| Is that the entire output of CheckDB?It looks like corruption in the system tables. CheckDB won't repair that and, in this case, it can't even check the DB because it can't get a view of what the database should look like?Do you have a clean backup of this database? If you do, restore it.If you don't have a backup, you're only real option is to script all the objects that you can, some will likely give errors, bcp out all the data that you can, create a new database, recreate the objects and reload all the data.--Gail ShawSQL Server MVP |
 |
|
|
greegy08
Starting Member
19 Posts |
Posted - 2009-07-05 : 20:23:56
|
| i think the table syscolumns have a problem because when i run dbcc checktable('syscolumns')the message result isServer: Msg 2511, Level 16, State 2, Line 1Table error: Object ID 3, Index ID 0. Keys out of order on page (1:1152), slots 15 and 16.DBCC results for 'syscolumns'.There are 15591 rows in 324 pages for object 'syscolumns'.CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'syscolumns' (object ID 3).repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (522.dbo.syscolumns ). Greegy08 SQl NooB |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-06 : 03:33:34
|
| That's a repairable error, put the DB into single user mode and run checktable on syscolumns with the repair_rebuild option. However I suspect there's another problem as well. A repairable error shouldn't have CheckDB complaining that consistency errors prevent further processing.Try the checktable with repair, then try checkDB again.--Gail ShawSQL Server MVP |
|
|
|
greegy08
Starting Member
19 Posts |
Posted - 2009-07-06 : 05:00:48
|
| hi good day sir!when i run DBCC CHECKtable ([syscolumns],REPAIR_REBUILD). I got the same error again..Server: Msg 2594, Level 16, State 1, Line 1Invalid index ID (0) specified.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 3, Index ID 0. Keys out of order on page (1:1152), slots 15 and 16.DBCC results for 'syscolumns'. Could not repair this error. There are 15591 rows in 324 pages for object 'syscolumns'.CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'syscolumns' (object ID 3).repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (522.dbo.syscolumns repair_rebuild).And when i try check db with the repair rebuild. also i get this error..Server: Msg 2594, Level 16, State 1, Line 1Invalid index ID (0) specified.Server: Msg 7995, Level 16, State 1, Line 1Database '522' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Other way to solve this kind of error?thanks again for the reply. Your reply is highly appreciated.Greegy08SQl NooB |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-06 : 05:03:01
|
| In that case we're not going to be able to repair. Go with what I said above. Restore a clean backup if you have one. If you don't script the objects out, bcp the data out and recreate the database.--Gail ShawSQL Server MVP |
|
|
|
greegy08
Starting Member
19 Posts |
Posted - 2009-07-06 : 22:41:43
|
| hi gail,Thanks again for your help.Greegy08SQl NooB |
|
|
|
|
|
|
|
|
dbcc error