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-05-12 : 19:21:37
|
| Guruswhen i run checkdb i get this error"Database 'master' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing."What can be the cause?Can i fix this with repair option of check db?Please adviceRegardsNitin |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-13 : 03:03:27
|
| You may want to re-ask this in the Data Corruption Issues forum."What can be the cause?"Most likely cause is hardware fault. Check your event log for any hardware error reports"Can i fix this with repair option of check db?"My understanding is that CHECKDB will tell you the minimum repair level needed to fix the problem and thus "... prevent further CHECKDB processing" suggests to me that there is no repair route possible and you should recover from backup.You should also CHECKDB all other databases on that server in case other databases have errors.Kristen |
 |
|
|
|
|
|
Error in master db(checkdb)