Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
псаломщик
Member

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

К сообщению приложен файл. Размер - 23Kb
10 май 12, 21:28    [12532884]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
Гавриленко Сергей Алексеевич
Member

Откуда:
Сообщений: 37254
DBCC CHECKDB. Довольно часто данная ошибка имеет быть при поврежденной базе данных.
11 май 12, 01:49    [12533700]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
псаломщик
Member

Откуда:
Сообщений: 13
Запустил DBCC CHECKDB без параметров - куча ошибок. Бекапа нет. Настроение ухудшается...
11 май 12, 15:26    [12537238]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
Александр52
Member

Откуда: Кокосовые острова ส็็็็็
Сообщений: 5136
может резервный сервер у вас есть или тестовый
11 май 12, 15:28    [12537261]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
псаломщик
Member

Откуда:
Сообщений: 13
Александр52, резервный или тестовый физический-железный сервер? Или еще один SQL-сервер?
11 май 12, 16:06    [12537581]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
псаломщик
Member

Откуда:
Сообщений: 13
Список ошибок - хватаюсь за голову...

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.
11 май 12, 16:20    [12537724]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
псаломщик
Member

Откуда:
Сообщений: 13
Для запуска DBCC CHECKDB нужно останавливать SQL-cервер? Наличие "зеркала" отчет не исказит?
11 май 12, 16:52    [12537981]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
Ozerov
Member

Откуда: Москва
Сообщений: 3637
псаломщик
Для запуска DBCC CHECKDB нужно останавливать SQL-cервер? Наличие "зеркала" отчет не исказит?


Как же Вы выполните DBCC CHECKDB на остановленном сервере ?...
на зеркале тоже битая база ?
11 май 12, 17:02    [12538043]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
псаломщик
Member

Откуда:
Сообщений: 13
Ozerov
Как же Вы выполните DBCC CHECKDB на остановленном сервере ?...

Понятия не имею, никогда эту команду не пробовал, но на каком-то форуме сегодня прочитал, что надо делать при остановленном сервере. Сам понял, что не в тему сказал...
Ozerov
на зеркале тоже битая база ?

Физически не проверял, но автоматом же, если на одном диске сбой, то сервер подхватывает "зеркальные" данные с другого. Грешу на диски, так как оба физических диска на момент сбоя были выделены в серверном менеджере дисков с пометкой "at risk". Cбросил эту пометку через "Reactivate Disk" - пока новых "at risk" не появилось...
11 май 12, 17:35    [12538218]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
londinium
Member

Откуда: Киев
Сообщений: 1199
мне помнится, DBCC CHECKDB выполняют на "отключенной базе"
ALTER DATABASE [DB_NAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
11 май 12, 18:10    [12538420]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка SQL "Could not continue scan with NOLOCK due to data movement"...  [new]
step_ks
Member

Откуда:
Сообщений: 936
londinium, это при repair
11 май 12, 18:19    [12538470]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить