|
fdewy
Starting Member
2 Posts |
 Posted - 2009-09-09 : 10:44:49
|
| I have encountered a recurring index corruption problem with just one particualr table in a database. This same database structure lives on multiple servers, different sql server versions, different hardware, ... etc. In each case it's always this same table. For this reason I do not believe that this is a hardware issue. My solution has been to select data out to a temp table, drop and re-create the corrupted table, then insert the records back in (from the corrupted temp table). this fixes the corruption every time with no loss of data. I'm investigating how this data is entering the database (data uploaded from handheld devise via xml post). My theory is that there is a problem in transmission but I don't have proof.Below is the result from dbcc checkdb showing the corruption. If any one has any ideas please or has had similar issues in the past, please let me know. Thanks.Msg 8929, Level 16, State 1, Line 1Object ID 1749541962, index ID 0, partition ID 72057594460504064, alloc unit ID 72057594477477888 (type In-row data): Errors found in off-row data with ID 91042152448 owned by data record identified by RID = (1:54952:1)Msg 8970, Level 16, State 1, Line 1Row error: Object ID 1749541962, index ID 0, partition ID 72057594460504064, alloc unit ID 72057594477477888 (type In-row data), page ID (1:54952), row ID 1. Column 'SigPts' was created NOT NULL, but is NULL in the row.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1749541962, index ID 0, partition ID 72057594460504064, alloc unit ID 72057594477543424 (type LOB data). The off-row data node at page (1:55118), slot 13, text ID 91042152448 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1749541962, index ID 0, partition ID 72057594460504064, alloc unit ID 72057594477543424 (type LOB data). The off-row data node at page (1:55248), slot 1, text ID 91042217984 is not referenced. |
|
Recurring index corruption on same table