Przeskanowałem bazę danych sql server management studio i w wynikach na czerwono wyskoczyło mi takie coś:
Msg 8944, Level 16, State 13, Line 1
Table error: Object ID 573245097, index ID 1, partition ID 72057613778223104, alloc unit ID 72057613980073984 (type In-row data), page (1:7856), row 115. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 8111 and 50.
Msg 8944, Level 16, State 13, Line 1
Table error: Object ID 573245097, index ID 1, partition ID 72057613778223104, alloc unit ID 72057613980073984 (type In-row data), page (1:7856), row 115. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 8111 and 50.
Msg 8928, Level 16, State 1, Line 1
Object ID 573245097, index ID 1, partition ID 72057613778223104, alloc unit ID 72057613980073984 (type In-row data): Page (1:7856) could not be processed. See other errors for details.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 573245097, index ID 1, partition ID 72057613778223104, alloc unit ID 72057613980073984 (type In-row data). Page (1:7856) was not seen in the scan although its parent (1:10824) and previous (1:7768) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 573245097, index ID 1, partition ID 72057613778223104, alloc unit ID 72057613980073984 (type In-row data). Page (1:7857) is missing a reference from previous page (1:7856). Possible chain linkage problem.
Czyli baza uszkodzona ? Do naprawy ?