Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
Traygod
Member

Откуда:
Сообщений: 82
Доброго дня, уважаемые форумчане. Собственно произошел сабж, есть база на неделю назад только, прогнал dbcc checkdb repair_rebuild - что-то исправилось как я понял, а дальше ума не приложу что делать, так как не спец по скулю. ( Сказали что можно с бэкапа вытащить недостающие таблицы(Лог прикрепляю), но даже ума не приложу что делать... Помогите пожалуйста.

+
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574913) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574915) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574916) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574918) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574920) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574921) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574955) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574956) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574958) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574960) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574961) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574963) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574964) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7574998) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7575001) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576170) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576173) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576175) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576176) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576178) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576179) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576181) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576184) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576186) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576187) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576189) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576192) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:7576194) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
The repair level on the DBCC statement caused this repair to be bypassed.
CHECKDB found 0 allocation errors and 28 consistency errors not associated with any single object.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574913) could not be processed. See other errors for details.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7574913) was not seen in the scan although its parent (1:7572864) and previous (1:7574912) refer to it. Check any previous errors.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574914) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7574914). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572864), slot 58 refers to child page (1:7574914) and previous child (1:7574913), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574915) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572864), slot 59 refers to child page (1:7574915) and previous child (1:7574914), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574916) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572864), slot 60 refers to child page (1:7574916) and previous child (1:7574915), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7574917) is missing a reference from previous page (1:7574916). Possible chain linkage problem.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574918) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7574918) was not seen in the scan although its parent (1:7572865) and previous (1:7574917) refer to it. Check any previous errors.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574919) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7574919). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 1 refers to child page (1:7574919) and previous child (1:7574918), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574920) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 2 refers to child page (1:7574920) and previous child (1:7574919), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574921) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 3 refers to child page (1:7574921) and previous child (1:7574920), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574922) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7574922). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 4 refers to child page (1:7574922) and previous child (1:7574921), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7574923) is missing a reference from previous page (1:7574922). Possible chain linkage problem.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574955) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7574955) was not seen in the scan although its parent (1:7572865) and previous (1:7574954) refer to it. Check any previous errors.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574956) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 38 refers to child page (1:7574956) and previous child (1:7574955), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574957) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7574957). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 39 refers to child page (1:7574957) and previous child (1:7574956), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574958) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 40 refers to child page (1:7574958) and previous child (1:7574957), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574959) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7574959). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 41 refers to child page (1:7574959) and previous child (1:7574958), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574960) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 42 refers to child page (1:7574960) and previous child (1:7574959), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574961) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 43 refers to child page (1:7574961) and previous child (1:7574960), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574962) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7574962). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 44 refers to child page (1:7574962) and previous child (1:7574961), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574963) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 45 refers to child page (1:7574963) and previous child (1:7574962), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574964) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 46 refers to child page (1:7574964) and previous child (1:7574963), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574965) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7574965). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572865), slot 47 refers to child page (1:7574965) and previous child (1:7574964), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7574966) is missing a reference from previous page (1:7574965). Possible chain linkage problem.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574998) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7574998) was not seen in the scan although its parent (1:7572866) and previous (1:7574997) refer to it. Check any previous errors.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7574999) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7574999). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572866), slot 19 refers to child page (1:7574999) and previous child (1:7574998), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7575000) is missing a reference from previous page (1:7574999). Possible chain linkage problem.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7575001) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7575001) was not seen in the scan although its parent (1:7572866) and previous (1:7575000) refer to it. Check any previous errors.
Repairing this error requires other errors to be corrected first.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7575002) is missing a reference from previous page (1:7575001). Possible chain linkage problem.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576169) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576169). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7576169) was not seen in the scan although its parent (1:7572886) and previous (1:7576168) refer to it. Check any previous errors.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576170) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 12 refers to child page (1:7576170) and previous child (1:7576169), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576171) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576171). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 13 refers to child page (1:7576171) and previous child (1:7576170), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7576172) is missing a reference from previous page (1:7576171). Possible chain linkage problem.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576173) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7576173) was not seen in the scan although its parent (1:7572886) and previous (1:7576172) refer to it. Check any previous errors.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576174) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576174). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 16 refers to child page (1:7576174) and previous child (1:7576173), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576175) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 17 refers to child page (1:7576175) and previous child (1:7576174), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576176) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 18 refers to child page (1:7576176) and previous child (1:7576175), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576177) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576177). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 19 refers to child page (1:7576177) and previous child (1:7576176), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576178) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 20 refers to child page (1:7576178) and previous child (1:7576177), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576179) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 21 refers to child page (1:7576179) and previous child (1:7576178), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576180) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576180). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 22 refers to child page (1:7576180) and previous child (1:7576179), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576181) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 23 refers to child page (1:7576181) and previous child (1:7576180), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576182) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576182). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 24 refers to child page (1:7576182) and previous child (1:7576181), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7576183) is missing a reference from previous page (1:7576182). Possible chain linkage problem.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576184) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7576184) was not seen in the scan although its parent (1:7572886) and previous (1:7576183) refer to it. Check any previous errors.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576185) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576185). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 27 refers to child page (1:7576185) and previous child (1:7576184), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576186) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 28 refers to child page (1:7576186) and previous child (1:7576185), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576187) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 29 refers to child page (1:7576187) and previous child (1:7576186), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576188) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576188). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 30 refers to child page (1:7576188) and previous child (1:7576187), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576189) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 31 refers to child page (1:7576189) and previous child (1:7576188), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576190) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576190). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 32 refers to child page (1:7576190) and previous child (1:7576189), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7576191) is missing a reference from previous page (1:7576190). Possible chain linkage problem.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576192) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7576192) was not seen in the scan although its parent (1:7572886) and previous (1:7576191) refer to it. Check any previous errors.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576193) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data), page (1:7576193). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113248265 and -4.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 35 refers to child page (1:7576193) and previous child (1:7576192), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8928, Level 16, State 1, Line 1
Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data): Page (1:7576194) could not be processed. See other errors for details.
Repairing this error requires other errors to be corrected first.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Index node page (1:7572886), slot 36 refers to child page (1:7576194) and previous child (1:7576193), but they were not encountered.
Repairing this error requires other errors to be corrected first.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1026206806, index ID 1, partition ID 72057657602539520, alloc unit ID 72057657583796224 (type In-row data). Page (1:7576195) is missing a reference from previous page (1:7576194). Possible chain linkage problem.
Repairing this error requires other errors to be corrected first.
CHECKDB found 0 allocation errors and 119 consistency errors in table '_AccumRgT20477' (object ID 1026206806).
CHECKDB found 0 allocation errors and 147 consistency errors in database 'optima'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (optima, repair_rebuild).
10 апр 18, 23:00    [21328041]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
Traygod
Member

Откуда:
Сообщений: 82
Забыл добавить в первом посте - если кто готов помочь на коммерческой основе, то пожалуйста стукните в личку, очень нужна помощь.
10 апр 18, 23:31    [21328078]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
angro
Member

Откуда:
Сообщений: 387
если у тебя sql ный бекап, то названия таблиц будут те же самые, подними бекап рядом и недостающие таблицы скопируй в поломанную бд. если попадёшь на таблицы итогов то повезло.
11 апр 18, 00:15    [21328141]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
Traygod
Member

Откуда:
Сообщений: 82
angro
если у тебя sql ный бекап, то названия таблиц будут те же самые, подними бекап рядом и недостающие таблицы скопируй в поломанную бд. если попадёшь на таблицы итогов то повезло.


Да, тупо перезалил с бэкапа таблицу и всё взлетело. Спасибо, тему можно закрыть.
11 апр 18, 08:41    [21328345]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 30726
Traygod
angro
если у тебя sql ный бекап, то названия таблиц будут те же самые, подними бекап рядом и недостающие таблицы скопируй в поломанную бд. если попадёшь на таблицы итогов то повезло.


Да, тупо перезалил с бэкапа таблицу и всё взлетело. Спасибо, тему можно закрыть.
А checkdb теперь ошибок не показывает?
Вы это проверьте, потому что ошибки могут остаться, причём они тогда будут и в следующих бакапах, и сложится очень неприятная ситуация.
11 апр 18, 09:41    [21328441]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
Traygod
Member

Откуда:
Сообщений: 82
alexeyvg
Traygod
пропущено...


Да, тупо перезалил с бэкапа таблицу и всё взлетело. Спасибо, тему можно закрыть.
А checkdb теперь ошибок не показывает?
Вы это проверьте, потому что ошибки могут остаться, причём они тогда будут и в следующих бакапах, и сложится очень неприятная ситуация.


Да, вы правы, рано радовался. В логе шла речь про таблицу _AccumRgT20477, я её снёс и перезалил с бэкапа, сейчас с ужасом обнаружил что там не было индексов - сейчас слил их бэкапа так же. Буду проверять ближе к вечеру, как люди выйдут. На ошибки пока никто не жаловался, но может ещё что-то не учёл при переносе таблицы?
11 апр 18, 12:49    [21329228]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
Traygod
Member

Откуда:
Сообщений: 82
alexeyvg
Traygod
пропущено...


Да, тупо перезалил с бэкапа таблицу и всё взлетело. Спасибо, тему можно закрыть.
А checkdb теперь ошибок не показывает?
Вы это проверьте, потому что ошибки могут остаться, причём они тогда будут и в следующих бакапах, и сложится очень неприятная ситуация.


CHECKDB found 0 allocation errors and 0 consistency errors in database
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Итак, судя по всему ошибок нет. Вопрос насколько откатились данные и откатились ли )) Нужно ли делать тестирование самой 1с, может на проверку целостности?
11 апр 18, 17:53    [21330734]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 30726
Traygod
Итак, судя по всему ошибок нет.
Отлично.
Traygod
Вопрос насколько откатились данные и откатились ли )) Нужно ли делать тестирование самой 1с, может на проверку целостности?
А как они могли откатиться?
Вы же не трогали вашу базу, вы только удалили дефектную таблицу, потом восстановили рядом базу из недельного бакапа, и потом из этой базы перелили таблицу в рабочую?

На проверку целостности - ну, можно, мало ли, может, ещё что то удалилось, когда вы "прогнал dbcc checkdb repair_rebuild - что-то исправилось"
12 апр 18, 01:01    [21331587]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
Yasha123
Member

Откуда:
Сообщений: 1833
alexeyvg
А как они могли откатиться?
Вы же не трогали вашу базу, вы только удалили дефектную таблицу, потом восстановили рядом базу из недельного бакапа, и потом из этой базы перелили таблицу в рабочую?

если у меня бэкап недельной давности,
по вчерашний день я вставляю данные вообще во все таблицы,
а сегодня база побилась и я пару таблиц тащу с того бэкапа,
то очевидно у меня во всех таблицах данные по сегодняшний день,
а в тех двух не хватает данных за неделю.
вот так и могли данные откатиться.
и никакой чекдб это не проверит.
так что если у 1С есть проверка логической согласованности, то чего бы и не проверить
----
раз такой вопрос возник,
то видимо ТС не знает точно, менялись ли данные в тех двух таблицах в течение последней недели
12 апр 18, 10:09    [21332200]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление базы 1с после повреждения секторов на жестком диске.  [new]
Dorosh
Member

Откуда:
Сообщений: 257
Traygod
Итак, судя по всему ошибок нет. Вопрос насколько откатились данные и откатились ли )) Нужно ли делать тестирование самой 1с, может на проверку целостности?


Повезло. Табличка _AccumRgT20477 это регистр накопления, а не первичка. Найти какому регистру она соответсвует и перепровести документы-регистраторы, вот и весь ремонт
12 апр 18, 11:01    [21332447]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить