Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...

При работе в 1С 7.7 на SQL вылетает ошибка "Could not continue scan with NOLOCK due to data movement" ошибка идет со ссылкой на SQL. Эта же ошибка возникает при запуске "Выгрузка данных" и "Тестирование и исправление". Работа с базой парализована. На сервере с базой установлено "зеркало". Что можно предпринять?

Миниатюры

 

0

Зеркало - в сад. Далее, разбираться. Клюшки на скуле - та еще фишка

1

Запустил DBCC CHECKDB без параметров - куча ошибок. Бекапа нет. Настроение ухудшается...
Список ошибок прилагается:

Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1419615). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1419616). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1419617). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1419618). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1419619). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1419622). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1419623). The PageId in the page header = (0:0).
DBCC results for 'torg_2011'.
CHECKDB found 0 allocation errors and 7 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 913 rows in 13 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 799 rows in 35 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3291 rows in 46 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 660 rows in 36 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 50 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 12 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 2021 rows in 10 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 0 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'RA3384'.
There are 873 rows in 5 pages for object 'RA3384'.
DBCC results for 'DT5390'.
There are 1328 rows in 21 pages for object 'DT5390'.
DBCC results for '_1SUIDCTL'.
There are 26 rows in 1 pages for object '_1SUIDCTL'.
DBCC results for 'RG3623'.
There are 158268 rows in 1998 pages for object 'RG3623'.
DBCC results for 'DH6053'.
There are 0 rows in 0 pages for object 'DH6053'.
DBCC results for 'SC5307'.
There are 0 rows in 0 pages for object 'SC5307'.
DBCC results for 'RA3623'.
There are 30348 rows in 493 pages for object 'RA3623'.
DBCC results for 'DH3580'.
There are 8 rows in 1 pages for object 'DH3580'.
DBCC results for 'SC4865'.
There are 87 rows in 6 pages for object 'SC4865'.
DBCC results for 'RG5398'.
There are 34 rows in 1 pages for object 'RG5398'.
DBCC results for 'DT3580'.
There are 7910 rows in 78 pages for object 'DT3580'.
DBCC results for 'SC1414'.
There are 6 rows in 1 pages for object 'SC1414'.
DBCC results for 'RA5398'.
There are 0 rows in 1 pages for object 'RA5398'.
DBCC results for 'DH912'.
There are 0 rows in 0 pages for object 'DH912'.
DBCC results for 'SC1112'.
There are 6 rows in 1 pages for object 'SC1112'.
DBCC results for 'RG99'.
There are 636542 rows in 7014 pages for object 'RG99'.
DBCC results for 'DT912'.
There are 0 rows in 0 pages for object 'DT912'.
DBCC results for 'SC89'.
There are 2 rows in 1 pages for object 'SC89'.
DBCC results for 'RA99'.
There are 2934432 rows in 25993 pages for object 'RA99'.
DBCC results for 'DH4382'.
There are 0 rows in 0 pages for object 'DH4382'.
DBCC results for 'SC4859'.
There are 4 rows in 1 pages for object 'SC4859'.
DBCC results for 'RG6118'.
There are 17624914 rows in 183259 pages for object 'RG6118'.
DBCC results for 'DT4382'.
There are 0 rows in 0 pages for object 'DT4382'.
DBCC results for 'SC5303'.
There are 4 rows in 1 pages for object 'SC5303'.
DBCC results for 'RA6118'.
There are 2358986 rows in 33138 pages for object 'RA6118'.
DBCC results for 'DH3831'.
There are 6 rows in 1 pages for object 'DH3831'.
DBCC results for 'SC4337'.
There are 93 rows in 2 pages for object 'SC4337'.
DBCC results for 'RG1130'.
There are 28303691 rows in 635688 pages for object 'RG1130'.
DBCC results for 'DT3831'.
There are 60 rows in 2 pages for object 'DT3831'.
DBCC results for 'SC3724'.
There are 527 rows in 9 pages for object 'SC3724'.
DBCC results for 'RA1130'.
There are 6025677 rows in 219858 pages for object 'RA1130'.
DBCC results for 'DH3487'.
There are 0 rows in 0 pages for object 'DH3487'.
DBCC results for 'SC131'.
There are 43268 rows in 478 pages for object 'SC131'.
DBCC results for 'RG620'.
There are 40 rows in 1 pages for object 'RG620'.
DBCC results for 'DT3487'.
There are 0 rows in 0 pages for object 'DT3487'.
DBCC results for 'SC5310'.
There are 0 rows in 0 pages for object 'SC5310'.
DBCC results for 'RA620'.
There are 0 rows in 1 pages for object 'RA620'.
DBCC results for 'DH519'.
There are 0 rows in 0 pages for object 'DH519'.
DBCC results for 'SC5298'.
There are 1 rows in 1 pages for object 'SC5298'.
DBCC results for 'RG6732'.
There are 415715 rows in 8051 pages for object 'RG6732'.
DBCC results for 'DT519'.
There are 0 rows in 0 pages for object 'DT519'.
DBCC results for 'SC3760'.
There are 0 rows in 0 pages for object 'SC3760'.
DBCC results for 'RA6732'.
There are 233451 rows in 4488 pages for object 'RA6732'.
DBCC results for 'DH6959'.
There are 0 rows in 0 pages for object 'DH6959'.
DBCC results for 'SC3764'.
There are 0 rows in 0 pages for object 'SC3764'.
DBCC results for 'RG7209'.
There are 5145428 rows in 49176 pages for object 'RG7209'.
DBCC results for 'DT6959'.
There are 0 rows in 0 pages for object 'DT6959'.
DBCC results for 'SC3763'.
There are 0 rows in 0 pages for object 'SC3763'.
DBCC results for '_1SCONNECT'.
There are 1 rows in 1 pages for object '_1SCONNECT'.
DBCC results for 'RA7209'.
There are 510752 rows in 6915 pages for object 'RA7209'.
DBCC results for 'DH239'.
There are 0 rows in 0 pages for object 'DH239'.
DBCC results for 'SC3769'.
There are 28 rows in 1 pages for object 'SC3769'.
DBCC results for 'RG7488'.
There are 0 rows in 0 pages for object 'RG7488'.
DBCC results for 'DT239'.
There are 0 rows in 0 pages for object 'DT239'.
DBCC results for 'SC3509'.
There are 0 rows in 0 pages for object 'SC3509'.
DBCC results for 'RA7488'.
There are 0 rows in 0 pages for object 'RA7488'.
DBCC results for 'DH4132'.
There are 1 rows in 1 pages for object 'DH4132'.
DBCC results for 'SC3751'.
There are 5 rows in 1 pages for object 'SC3751'.
DBCC results for 'RG7496'.
There are 0 rows in 0 pages for object 'RG7496'.
DBCC results for 'DT4132'.
There are 1 rows in 1 pages for object 'DT4132'.
DBCC results for 'SC681'.
There are 0 rows in 0 pages for object 'SC681'.
DBCC results for 'RA7496'.
There are 0 rows in 0 pages for object 'RA7496'.
DBCC results for 'DH3287'.
There are 0 rows in 0 pages for object 'DH3287'.
DBCC results for 'SC46'.
There are 251 rows in 26 pages for object 'SC46'.
DBCC results for '_1SSTREAM'.
There are 1 rows in 1 pages for object '_1SSTREAM'.
DBCC results for 'DH434'.
There are 13545 rows in 471 pages for object 'DH434'.
DBCC results for 'SC31'.
There are 1 rows in 1 pages for object 'SC31'.
DBCC results for 'DT434'.
There are 92318 rows in 1510 pages for object 'DT434'.
DBCC results for 'SC33'.
There are 44141 rows in 2987 pages for object 'SC33'.
DBCC results for 'DH493'.
There are 17887 rows in 1538 pages for object 'DH493'.
DBCC results for 'SC838'.
There are 8 rows in 1 pages for object 'SC838'.
DBCC results for 'DT493'.
There are 377416 rows in 6026 pages for object 'DT493'.
DBCC results for 'SC544'.
There are 2871 rows in 61 pages for object 'SC544'.
DBCC results for 'DH2964'.
There are 425 rows in 28 pages for object 'DH2964'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 946102411, index ID 0: Page (1:1419616) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 946102411, index ID 0: Page (1:1419617) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 946102411, index ID 0: Page (1:1419618) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 946102411, index ID 0: Page (1:1419619) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 946102411, index ID 0: Page (1:1419622) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 946102411, index ID 0: Page (1:1419623) could not be processed. See other errors for details.
DBCC results for 'SC1183'.
There are 86 rows in 4 pages for object 'SC1183'.
DBCC results for 'DH410'.
There are 7274 rows in 1310 pages for object 'DH410'.
DBCC results for 'SC5315'.
There are 0 rows in 0 pages for object 'SC5315'.
DBCC results for 'DT410'.
There are 192131 rows in 3122 pages for object 'DT410'.
DBCC results for 'SC5654'.
There are 0 rows in 0 pages for object 'SC5654'.
DBCC results for 'DH469'.
There are 21055 rows in 2032 pages for object 'DH469'.
DBCC results for 'SC5461'.
There are 0 rows in 0 pages for object 'SC5461'.
DBCC results for 'DT469'.
There are 800230 rows in 10189 pages for object 'DT469'.
CHECKDB found 0 allocation errors and 6 consistency errors in table 'DT469' (object ID 946102411).
DBCC results for 'SC6093'.
There are 4 rows in 1 pages for object 'SC6093'.
DBCC results for 'DH3436'.
There are 0 rows in 0 pages for object 'DH3436'.
DBCC results for 'SC6596'.
There are 4 rows in 1 pages for object 'SC6596'.
DBCC results for 'DT3436'.
There are 0 rows in 0 pages for object 'DT3436'.
DBCC results for 'SC3246'.
There are 13 rows in 1 pages for object 'SC3246'.
DBCC results for 'DH2978'.
There are 453 rows in 37 pages for object 'DH2978'.
DBCC results for 'SC3649'.
There are 1 rows in 1 pages for object 'SC3649'.
DBCC results for 'DH773'.
There are 0 rows in 0 pages for object 'DH773'.
DBCC results for 'SC5744'.
There are 8 rows in 1 pages for object 'SC5744'.
DBCC results for 'DT773'.
There are 0 rows in 0 pages for object 'DT773'.
DBCC results for 'SC13'.
There are 6 rows in 1 pages for object 'SC13'.
DBCC results for 'DH5667'.
There are 0 rows in 0 pages for object 'DH5667'.
DBCC results for 'SC3772'.
There are 150153 rows in 1895 pages for object 'SC3772'.
DBCC results for 'DT5667'.
There are 0 rows in 0 pages for object 'DT5667'.
DBCC results for 'SC6792'.
There are 0 rows in 0 pages for object 'SC6792'.
DBCC results for 'DH627'.
There are 0 rows in 0 pages for object 'DH627'.
DBCC results for 'SC6872'.
There are 0 rows in 0 pages for object 'SC6872'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'DT627'.
There are 0 rows in 0 pages for object 'DT627'.
DBCC results for 'SC6881'.
There are 0 rows in 0 pages for object 'SC6881'.
DBCC results for 'DH297'.
There are 309 rows in 9 pages for object 'DH297'.
DBCC results for 'DH3538'.
There are 0 rows in 0 pages for object 'DH3538'.
DBCC results for 'DT297'.
There are 7501 rows in 91 pages for object 'DT297'.
DBCC results for 'DT3538'.
There are 0 rows in 0 pages for object 'DT3538'.
DBCC results for 'DH196'.
There are 22 rows in 1 pages for object 'DH196'.
DBCC results for 'DH5661'.
There are 0 rows in 0 pages for object 'DH5661'.
DBCC results for 'DT196'.
There are 22 rows in 1 pages for object 'DT196'.
DBCC results for 'DT5661'.
There are 0 rows in 0 pages for object 'DT5661'.
DBCC results for 'DH730'.
There are 654 rows in 29 pages for object 'DH730'.
DBCC results for 'DH672'.
There are 59 rows in 3 pages for object 'DH672'.
DBCC results for 'DT730'.
There are 7240 rows in 151 pages for object 'DT730'.
DBCC results for 'DH657'.
There are 0 rows in 0 pages for object 'DH657'.
DBCC results for 'DH3454'.
There are 0 rows in 0 pages for object 'DH3454'.
DBCC results for 'DT657'.
There are 0 rows in 0 pages for object 'DT657'.
DBCC results for 'DT3454'.
There are 0 rows in 0 pages for object 'DT3454'.
DBCC results for 'DH5598'.
There are 709 rows in 29 pages for object 'DH5598'.
DBCC results for 'DH6387'.
There are 818 rows in 30 pages for object 'DH6387'.
DBCC results for 'DT5598'.
There are 9510 rows in 197 pages for object 'DT5598'.
DBCC results for 'DT6387'.
There are 31828 rows in 5065 pages for object 'DT6387'.
DBCC results for 'DH310'.
There are 0 rows in 0 pages for object 'DH310'.
DBCC results for 'DH7151'.
There are 24 rows in 1 pages for object 'DH7151'.
DBCC results for 'DT310'.
There are 0 rows in 0 pages for object 'DT310'.
DBCC results for 'DT7151'.
There are 24 rows in 1 pages for object 'DT7151'.
DBCC results for 'DH1160'.
There are 0 rows in 0 pages for object 'DH1160'.
DBCC results for 'DH7194'.
There are 409 rows in 12 pages for object 'DH7194'.
DBCC results for 'DT1160'.
There are 0 rows in 0 pages for object 'DT1160'.
DBCC results for 'DT7194'.
There are 22693 rows in 234 pages for object 'DT7194'.
DBCC results for 'DH1058'.
There are 0 rows in 0 pages for object 'DH1058'.
DBCC results for 'DH7338'.
There are 0 rows in 1 pages for object 'DH7338'.
DBCC results for 'DT1058'.
There are 0 rows in 0 pages for object 'DT1058'.
DBCC results for 'DT7338'.
There are 0 rows in 1 pages for object 'DT7338'.
DBCC results for 'DH4914'.
There are 323 rows in 10 pages for object 'DH4914'.
DBCC results for 'DH7416'.
There are 0 rows in 1 pages for object 'DH7416'.
DBCC results for 'DT4914'.
There are 2607 rows in 29 pages for object 'DT4914'.
DBCC results for 'DH7512'.
There are 6 rows in 1 pages for object 'DH7512'.
DBCC results for 'DH6475'.
There are 415 rows in 34 pages for object 'DH6475'.
DBCC results for 'DT7512'.
There are 66 rows in 1 pages for object 'DT7512'.
DBCC results for 'DT6475'.
There are 24825 rows in 3827 pages for object 'DT6475'.
DBCC results for 'DH7551'.
There are 44 rows in 2 pages for object 'DH7551'.
DBCC results for 'DH7018'.
There are 419 rows in 37 pages for object 'DH7018'.
DBCC results for 'DT7551'.
There are 225 rows in 4 pages for object 'DT7551'.
DBCC results for 'DT7018'.
There are 26620 rows in 3873 pages for object 'DT7018'.
DBCC results for 'RG169'.
There are 180716 rows in 4370 pages for object 'RG169'.
DBCC results for 'DH6640'.
There are 0 rows in 0 pages for object 'DH6640'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. Page (1:1418986) is missing a reference from previous page (1:1418985). Possible chain linkage problem.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 11. The previous link (1:1415544) on page (1:1165258) does not match the previous page (1:1415549) that the parent (1:206882), slot 186 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 11. B-tree chain linkage mismatch. (1:1415549)->next = (1:1165258), but (1:1165258)->Prev = (1:1415544).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 11. The high key value on page (1:1415549) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:1165258).
DBCC results for 'RA169'.
There are 46083 rows in 1620 pages for object 'RA169'.
DBCC results for 'DT6640'.
There are 0 rows in 0 pages for object 'DT6640'.
DBCC results for 'RG933'.
There are 171866 rows in 2401 pages for object 'RG933'.
DBCC results for 'DH2989'.
There are 51 rows in 1 pages for object 'DH2989'.
DBCC results for '_1SUSERS'.
There are 1 rows in 1 pages for object '_1SUSERS'.
DBCC results for '_1SSYSTEM'.
There are 1 rows in 1 pages for object '_1SSYSTEM'.
DBCC results for 'RA933'.
There are 34188 rows in 527 pages for object 'RA933'.
DBCC results for 'DT2989'.
There are 211 rows in 6 pages for object 'DT2989'.
DBCC results for '_1SCONST'.
There are 682655 rows in 5754 pages for object '_1SCONST'.
DBCC results for 'RG4333'.
There are 611 rows in 6 pages for object 'RG4333'.
DBCC results for 'DH844'.
There are 33 rows in 3 pages for object 'DH844'.
DBCC results for '_1SJOURN'.
There are 64984 rows in 1467 pages for object '_1SJOURN'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 1. Page (1:1418709) is missing a reference from previous page (1:1419583). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1361805) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1386425) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1386426) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1386427) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1386428) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1386429) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1386430) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1386431) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1386496) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1404256) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1404257) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1404258) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1404259) was not encountered.
CHECKDB found 0 allocation errors and 4 consistency errors in table '_1SJOURN' (object ID 2073058421).
DBCC results for 'RA4333'.
There are 56 rows in 1 pages for object 'RA4333'.
DBCC results for 'DT844'.
There are 33 rows in 1 pages for object 'DT844'.
DBCC results for '_1SCRDOC'.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1404260) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1404261) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1416539) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1416540) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1416541) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1416542) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1416543) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1417712) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1417713) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1417714) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1417715) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1417716) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1417717) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1417718) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1417719) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418040) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418041) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418042) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418043) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418044) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418045) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418046) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418047) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418080) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418081) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418082) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418083) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418084) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418086) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418087) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418968) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418969) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418970) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418971) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418972) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418973) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418974) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418975) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418992) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418993) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418994) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418995) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418996) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418997) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418998) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1418999) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419488) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419489) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419490) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419491) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419492) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419493) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419494) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419495) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419536) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419537) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419538) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419539) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419540) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419541) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419542) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419543) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419568) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419569) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419570) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419571) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419572) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419573) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419574) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419575) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419608) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419609) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419610) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419611) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419612) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419613) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419614) was not encountered.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2105058535, index ID 2: Page (1:1419615) could not be processed. See other errors for details.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Page (1:1419648) is missing references from parent (unknown) and previous (page (1:1419614)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419649) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 2. Parent node for page (1:1419650) was not encountered.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 3. The previous link (1:1419527) on page (1:1413152) does not match the previous page (1:1419639) that the parent (1:1418121), slot 19 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 3. B-tree chain linkage mismatch. (1:1419639)->next = (1:1413152), but (1:1413152)->Prev = (1:1419527).
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 2105058535, index ID 3. Page (1:1419632) is missing a reference from previous page (1:1191806). Possible chain linkage problem.
There are 1892307 rows in 20406 pages for object '_1SCRDOC'.
CHECKDB found 0 allocation errors and 98 consistency errors in table '_1SCRDOC' (object ID 2105058535).
DBCC results for 'RG3384'.
There are 28 rows in 1 pages for object 'RG3384'.
DBCC results for 'DH5390'.
There are 65 rows in 3 pages for object 'DH5390'.
DBCC results for '_1SDNLOCK'.
There are 0 rows in 1 pages for object '_1SDNLOCK'.
CHECKDB found 0 allocation errors and 115 consistency errors in database 'torg_2011'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (torg_2011 ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

0

О-хо-хо. Вариант без зеркала неприемлем?

0

В смысле отключить вторые "зеркальные" диски?

0

Так ты про RAID имел ввиду?

Добавлено через 1 минуту
Опиши проблему поподробнее - с чего началось, работало ли вообще когда либо. Попробуй сделать бэкап (средствами 1с и средствами сервака). Раскрути на другом сервере.

1

Да, рэйд. А ты про дополнительный резервный SQL-cервер подумал?
Началось все неожиданно, в разгар рабочего дня при вводе документов...

Если делать "Выгрузить данные" средствами 1С, то появляется нелюбимая надпись "Could not continue scan with NOLOCK due to data movement". Бекап средствами SQL сделать получилось, но после его загрузке в другую базу на том же SQL-сервере имеем ту же "Could not continue scan with NOLOCK due to data movement"...

0

http://www.1csql.ru/materials/... 7f1eae5313

Добавлено через 3 минуты
В общем пробуй repair - хуже уже не будет

1

pincet, ссылка была на это?

"В BOL причина ошибки связана с сочетанием блокировки (NOLOCK) и уровнем изоляции (READ UNCOMMITED) таким образом, что при чтении данных некоторые прочитанные страницы могут быть удалены до завершения транзакции. Нам это ничего не дает. Кажется, что проблема связана с проектированием 1С. На самом деле система использует другой уровень изоляции, который не может привести к такой ситуации. Обычно ошибка появляется при разрушении данных. На моей памяти это было в двух случаях. Проверка БД производится как обычно с помощью DBCC CHECKDB. Если данные разрушены, то команда выдаст список объектов, в которых найдены повреждения. Сделайте резервную копию и попытайтесь с помощью все той же DBCC CHECKDB восстановить данные. Если повреждения несерьезные, то восстановление проходит гладко. Если нет, то проще произвести восстановление БД из резервной копии.

Совет. Чтобы не возникало данной ошибки, следите за местом на диске, следите за состоянием вашей дисковой системы, ставьте на сервер ИБП, делайте резервные копии."

0

да. погугли текст ошибки - может мысли какие в голову придут.

0

pincet, текст ошибки имеется ввиду "Could not continue scan with NOLOCK due to data movement"? Ты не про тот длинный список, который выдала DBCC CHECKDB?

0

Да. В твоем логе печалька в том числе и таблицей _1SJOURN - журнал документов.

1

Да есть там такая "печалька". Это результат, который мне выдал SQL Query Analyzer на DBCC CHECKDB. Думаю еще попробовать запустить на сервере Chkdsk - вдруг что выдаст интересное...

0