![]() My thoughts would be:Likely cause is Disk I/O fault. Extra or invalid key for the keys:Server: Msg 8956, Level 16, State 1, Line 1Index row (1:425:11) with values (id = 1794105432 and name = 'COLUMN_NAME' and number = 0 and id = 1794105432 and colid = 4 and number = 0) points to the data row identified by ().CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'syscolumns' (object ID 3).repair_fast is the minimum repair level for the errors found by DBCC CHECKTABLE ( ).Since this a master database, I am not sure on what action to take nextThank you Hi,dbcc checkdb failed on master database on one of my production serverCould not find the index entry for RID ''1658e0ef6a04000000030000'' in index page (1:434), index ID 0, database ''master''.I execute DBCC CHECKTABLE (syscolumns) WITH NO_INFOMSGS, ALL_ERRORMSGSHere is the output :Server: Msg 8952, Level 16, State 1, Line 1Table error: Database 'master', index 'syscolumns.ncsyscolumns' (ID 3) (index ID 2). ![]() ![]() We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |