Errror message in Master DB - 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

General SQL Server Forums

Data Corruption Issues

Errror message in Master DB

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.)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources