![Piotr Z.](https://static.goldenline.pl/user_hidden_basic.jpg)
Piotr Z. programista
Temat: Błędy na bazie
Witam,Problem jest nastepujący, otóż po uruchomieniu polecenia
DBCC CHECKDB WITH NO_INFOMSGS
Dostałem następujący wynik:
Msg 2570, Level 16, State 3, Line 1
Page (1:34734), slot 42 in object ID 167671645, index ID 0, partition ID 72057594256031744, alloc unit ID 72057594188660736 (type "In-row data"). Column "KWOTA_WN_W" value is out of range for data type "decimal". Update column to a legal value.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'POZ_DOK' (object ID 167671645).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 238623893, index ID 1, partition ID 72057594188070912, alloc unit ID 72057594189840384 (type In-row data). The high key value on page (1:6958) (level 0) is not less than the low key value in the parent (1:6794), slot 246 of the next page (1:6959).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 238623893, index ID 1, partition ID 72057594188070912, alloc unit ID 72057594189840384 (type In-row data). The high key value on page (1:7070) (level 0) is not less than the low key value in the parent (1:6794), slot 254 of the next page (1:7071).
Msg 8934, Level 16, State 3, Line 1
Table error: Object ID 238623893, index ID 1, partition ID 72057594188070912, alloc unit ID 72057594189840384 (type In-row data). The high key value on page (1:7070) (level 0) is not less than the low key value in the parent (1:6794), slot 254 of the next page (1:7071).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 238623893, index ID 1, partition ID 72057594188070912, alloc unit ID 72057594189840384 (type In-row data). The high key value on page (1:15582) (level 0) is not less than the low key value in the parent (1:6494), slot 163 of the next page (1:15583).
Msg 8934, Level 16, State 3, Line 1
Table error: Object ID 238623893, index ID 1, partition ID 72057594188070912, alloc unit ID 72057594189840384 (type In-row data). The high key value on page (1:15582) (level 0) is not less than the low key value in the parent (1:6494), slot 163 of the next page (1:15583).
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 238623893, index ID 10, partition ID 72057594188660736, alloc unit ID 72057594190430208 (type In-row data). Keys out of order on page (1:69664), slots 16 and 17.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 238623893, index ID 13, partition ID 72057594188857344, alloc unit ID 72057594190626816 (type In-row data). Keys out of order on page (1:48678), slots 181 and 182.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 238623893, index ID 16, partition ID 72057594189053952, alloc unit ID 72057594190823424 (type In-row data). Keys out of order on page (1:40726), slots 194 and 195.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 238623893, index ID 16, partition ID 72057594189053952, alloc unit ID 72057594190823424 (type In-row data). Keys out of order on page (1:40950), slots 254 and 255.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 238623893, index ID 22, partition ID 72057594189381632, alloc unit ID 72057594191151104 (type In-row data). Keys out of order on page (1:43246), slots 410 and 411.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 238623893, index ID 25, partition ID 72057594189578240, alloc unit ID 72057594191347712 (type In-row data). Keys out of order on page (1:34622), slots 254 and 255.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 238623893, index ID 31, partition ID 72057594189971456, alloc unit ID 72057594191740928 (type In-row data). Keys out of order on page (1:20174), slots 18 and 19.
CHECKDB found 0 allocation errors and 12 consistency errors in table 'ROZRACHUNEK' (object ID 238623893).
Czy ktoś wie co można z tym zrobić ?
Piotr.