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 |
|
respectablename00
Starting Member
2 Posts |
 Posted - 2008-06-30 : 13:30:44
|
| Customer's database has corrupted table (I think).DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGSreadsMsg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (default_object_id=542589806) of row (object_id=412892888,column_id=13) in sys.columns does not have a matching row (object_id=542589806) in sys.objects.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (default_object_id=1140497961) of row (object_id=268892375,column_id=12) in sys.columns does not have a matching row (object_id=1140497961) in sys.objects.CHECKDB found 0 allocation errors and 2 consistency errors not associated with any single object.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 412892888, index ID 1, partition ID 308534325018624, alloc unit ID 27059348307968 (type In-row data). Page (1:4822) is missing a reference from previous page (1:4820). Possible chain linkage problem.Msg 8981, Level 16, State 1, Line 1Table error: Object ID 412892888, index ID 1, partition ID 308534325018624, alloc unit ID 27059348307968 (type In-row data). The next pointer of (1:4820) refers to page (1:4199126). Neither (1:4199126) nor its parent were encountered. Possible bad chain linkage.CHECKDB found 0 allocation errors and 2 consistency errors in table 'esCutOutDetail' (object ID 412892888).CHECKDB found 0 allocation errors and 4 consistency errors in database 'FRANKLIN_SQL_DAT'. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-01 : 02:23:07
|
| Looks like corruption and someone fiddling with the system tables. Was this DB upgraded from SQL 2000?Do you have a backup?--Gail Shaw |
 |
|
|
respectablename00
Starting Member
2 Posts |
Posted - 2008-07-01 : 10:27:16
|
| All of our customer databases were at one time 2000, and they have been upgraded intermitently to 2005. I am not aware of a backup, but I am not the support rep who is talking with the customer. I am just one of the programmers trying to help out. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-01 : 16:09:40
|
| Can you find out if there is a up to date backup? The best (and recommended) way to fix corruption is to restore to a clean backup then use transaction log backups to get up to date.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
CHECKDB Msg 8992, 8978