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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-01-24 : 13:32:17
|
Gurus
I have a problem in hand.when i do dbcc check DB i get this error
"Database 'master' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing."
i installed sqlserver again and restored all the user databases.
but now again when i do dbcc check db this message is coming again.Please suggest me something
Regards
Nitin |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-01-24 : 21:37:18
|
Can you run the following commands in the master db and post the results please? (If you need immediate help, I suggest you contact CSS as I may not see/reply until late Wednesday)
DBCC CHECKTABLE (sysindexes) WITH NO_INFOMSGS, ALL_ERRORMSGS
go
DBCC CHECKTABLE (sysobjects) WITH NO_INFOMSGS, ALL_ERRORMSGS
go
DBCC CHECKTABLE (syscolumns) WITH NO_INFOMSGS, ALL_ERRORMSGS
go
DBCC CHECKTABLE (systypes) WITH NO_INFOMSGS, ALL_ERRORMSGS
go
My guess is that you've got a bad page in the clustered index of one of these tables - this is unrepairable. You'll need to restore or rebuild master to get around this. Depending on what the error is, you should check for h/w issues that could have caused it. Did anything out of the ordinary happen before you started getting these errors?
Thanks
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-01-25 : 16:20:07
|
Hi
Following is the error message.Please help
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 3, index ID 0: Page (1:1079) could not be processed. See other errors for details.
Server: Msg 8940, Level 16, State 1, Line 1
Table error: Object ID 3, index ID 0, page (1:1079). Test (IsAligned (sorted[i].offset)) failed. Address 0xb2 is not aligned.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 3, index ID 1. Page (1:601) is missing a reference from previous page (1:1079). Possible chain linkage problem.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 3, index ID 1. Page (1:1079) was not seen in the scan although its parent (1:17) and previous (1:678) refer to it. Check any previous errors.
CHECKTABLE found 0 allocation errors and 4 consistency errors in table 'syscolumns' (object ID 3).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (master.dbo.syscolumns ).
Regards
Nitin |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-01-25 : 22:20:02
|
This isn't repairable through any documented or undocumented means. You'll need to restore from your backups (you do have up-to-date backups, right?) or extract the data into a new database.
Did you check for h/w issues? Did anything out of the ordinary happen before this occured? What prompted you to run CHECKDB?
Thanks
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
|
|
Errror message in Master DB