DBCC CHECKDB with PHYSICAL_ONLY

Hola, revisa el mismo comando dbcc checkdb para reparar el error


Saludos

[Microsoft MVP SQL Server]
www.sqlgurus.org
Buenos Aires - Argentina
"AlejoR" wrote in message
news:

Que tal grupo.
Hice un chequeo de la base de datos y me arroja este mensaje!
No entiendo mucho de lo que significa,, un help para solucionarlo.

El problema es que varias consultas estan sacando error!
SQLSERVER 2000 SP4

DBCC CHECKDB with PHYSICAL_ONLY

Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1806681534, index ID 0: Page (1:511558) could not be processed.
See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1806681534, index ID 0, page (1:511558), row 1.
Test
(columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed.
Values
are 653 and 445.
DBCC results for 'SIDOJ'.
There are 0 rows in 0 pages for object 'SUH_NORMAS'.
CHECKDB found 0 allocation errors and 2 consistency errors in table
'SUH_NORMAS' (object ID 1806681534).
CHECKDB found 0 allocation errors and 2 consistency errors in database
'SIDOJ'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (SIDOJ ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Hola Alejo:
Significa que hay una problema de consistencia en tu base de datos. Este
problema se produce con frecuencia por problemas con el disco duro donde
esta almacenada la bd.
Ejecuta el comando:
DBCC CHECKDB ('SIDOJ', REPAIR_FAST)
o mejor todavia:
DBCC CHECKDB ('SIDOJ', REPAIR_REBUILD )
Este deberia reparar el problema, y luego de correrlo te recomiendo que
hagar un respaldo de la BD por si acaso te sigue dando problema el disco.
Saludos,

Javier Loria
Costa Rica-MVP
Solid Quality Learning
"AlejoR" wrote in message
news:

Que tal grupo.
Hice un chequeo de la base de datos y me arroja este mensaje!
No entiendo mucho de lo que significa,, un help para solucionarlo.

El problema es que varias consultas estan sacando error!
SQLSERVER 2000 SP4

DBCC CHECKDB with PHYSICAL_ONLY

Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1806681534, index ID 0: Page (1:511558) could not be processed.
See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1806681534, index ID 0, page (1:511558), row 1.
Test
(columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed.
Values
are 653 and 445.
DBCC results for 'SIDOJ'.
There are 0 rows in 0 pages for object 'SUH_NORMAS'.
CHECKDB found 0 allocation errors and 2 consistency errors in table
'SUH_NORMAS' (object ID 1806681534).
CHECKDB found 0 allocation errors and 2 consistency errors in database
'SIDOJ'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (SIDOJ ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Esto es lo que salio al hacer el chequeo

dbcc checkdb ('SIDOJ', REPAIR_FAST)

DBCC results for 'DOB_ESTADO_DEL_PROCESO'.
There are 3 rows in 1 pages for object 'DOB_ESTADO_DEL_PROCESO'.
DBCC results for 'SUH_NORMAS'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1806681534, index ID 0: Page (1:511558) could not be processed.
See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1806681534, index ID 0, page (1:511558), row 1. Test
(columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values
are 653 and 445.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513529), slot 1, text ID 65813479424 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513529), slot 2, text ID 65813544960 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513539), slot 1, text ID 65813610496 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513539), slot 3, text ID 65813676032 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513560), slot 1, text ID 65813741568 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513621), slot 1, text ID 65813807104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513682), slot 1, text ID 65813872640 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513682), slot 2, text ID 65813938176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513682), slot 3, text ID 65814003712 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513695), slot 1, text ID 65814069248 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513705), slot 1, text ID 65814134784 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513705), slot 2, text ID 65814200320 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513705), slot 4, text ID 65814265856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513718), slot 1, text ID 65814331392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513728), slot 1, text ID 65814396928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513728), slot 3, text ID 65814462464 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513728), slot 4, text ID 65814528000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513739), slot 1, text ID 65814593536 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513746), slot 1, text ID 65814659072 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513746), slot 2, text ID 65814724608 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513752), slot 1, text ID 65814790144 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513767), slot 1, text ID 65814855680 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513782), slot 1, text ID 65814921216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513782), slot 3, text ID 65814986752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513790), slot 1, text ID 65815052288 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513815), slot 1, text ID 65815117824 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 1, text ID 65815183360 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 2, text ID 65815248896 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 3, text ID 65815314432 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 5, text ID 65815379968 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513848), slot 1, text ID 65815445504 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513848), slot 2, text ID 65815511040 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513857), slot 1, text ID 65815576576 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513883), slot 1, text ID 65815642112 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513909), slot 1, text ID 65815707648 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513909), slot 3, text ID 65815773184 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513916), slot 1, text ID 65815838720 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513924), slot 1, text ID 65815904256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513932), slot 1, text ID 65815969792 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513932), slot 2, text ID 65816035328 is not referenced.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513942), slot 1, text ID 65816100864 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513964), slot 1, text ID 65816166400 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513986), slot 1, text ID 65816231936 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513986), slot 3, text ID 65816297472 is not referenced.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
There are 16163 rows in 1360 pages for object 'SUH_NORMAS'.
CHECKDB found 0 allocation errors and 46 consistency errors in table
'SUH_NORMAS' (object ID 1806681534).
DBCC results for '_SUB_ENTIDAD'.
There are 288 rows in 5 pages for object '_SUB_ENTIDAD'.
DBCC results for 'SUT_JURISPRUDENCIA'.
There are 0 rows in 0 pages for object 'SUT_JURISPRUDENCIA'.
DBCC results for 'SUB_DESCRIPTOR_TEMATICO'.
There are 3569 rows in 67 pages for object 'SUB_DESCRIPTOR_TEMATICO'.
DBCC results for 'SUB_ESTADO_NORMA'.
There are 6 rows in 1 pages for object 'SUB_ESTADO_NORMA'.
DBCC results for 'SUH_APARTES_REGLAMENTA'.
There are 0 rows in 1 pages for object 'SUH_APARTES_REGLAMENTA'.
DBCC results for 'dtproperties'.
There are 42 rows in 1 pages for object 'dtproperties'.
DBCC results for 'SUH_JURISPRUDENCIA'.
There are 4170 rows in 102 pages for object 'SUH_JURISPRUDENCIA'.
DBCC results for 'SUB_ENTIDAD_PUBLICA'.
There are 307 rows in 5 pages for object 'SUB_ENTIDAD_PUBLICA'.
DBCC results for 'DOB_ACTUACION_PROCESAL'.
There are 3 rows in 1 pages for object 'DOB_ACTUACION_PROCESAL'.
CHECKDB found 0 allocation errors and 46 consistency errors in database
'SIDOJ'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (SIDOJ repair_fast).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.


Y ahi que se puede hacer?
Gracias!


"Javier Loria" wrote:

Hola Alejo:
Significa que hay una problema de consistencia en tu base de datos. Este
problema se produce con frecuencia por problemas con el disco duro donde
esta almacenada la bd.
Ejecuta el comando:
DBCC CHECKDB ('SIDOJ', REPAIR_FAST)
o mejor todavia:
DBCC CHECKDB ('SIDOJ', REPAIR_REBUILD )
Este deberia reparar el problema, y luego de correrlo te recomiendo que
hagar un respaldo de la BD por si acaso te sigue dando problema el disco.
Saludos,

Javier Loria
Costa Rica-MVP
Solid Quality Learning
"AlejoR" wrote in message
news:
> Que tal grupo.
> Hice un chequeo de la base de datos y me arroja este mensaje!
> No entiendo mucho de lo que significa,, un help para solucionarlo.
>
> El problema es que varias consultas estan sacando error!
> SQLSERVER 2000 SP4
>
> DBCC CHECKDB with PHYSICAL_ONLY
>
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 1806681534, index ID 0: Page (1:511558) could not be processed.
> See other errors for details.
> Server: Msg 8944, Level 16, State 1, Line 1
> Table error: Object ID 1806681534, index ID 0, page (1:511558), row 1.
> Test
> (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed.
> Values
> are 653 and 445.
> DBCC results for 'SIDOJ'.
> There are 0 rows in 0 pages for object 'SUH_NORMAS'.
> CHECKDB found 0 allocation errors and 2 consistency errors in table
> 'SUH_NORMAS' (object ID 1806681534).
> CHECKDB found 0 allocation errors and 2 consistency errors in database
> 'SIDOJ'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKDB (SIDOJ ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>

Hola Alejo:
Ya se hicieron algunas correcciones con el comando, pero quedaron
algunas pendientes, prueba ahora con: DBCC CHECKDB ('SIDOJ',
REPAIR_REBUILD ) que es mas exaustivo.
Saludos


Javier Loria
Costa Rica-MVP
Solid Quality Learning

"AlejoR" wrote in message
news:

Esto es lo que salio al hacer el chequeo

dbcc checkdb ('SIDOJ', REPAIR_FAST)

DBCC results for 'DOB_ESTADO_DEL_PROCESO'.
There are 3 rows in 1 pages for object 'DOB_ESTADO_DEL_PROCESO'.
DBCC results for 'SUH_NORMAS'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1806681534, index ID 0: Page (1:511558) could not be processed.
See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1806681534, index ID 0, page (1:511558), row 1.
Test
(columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed.
Values
are 653 and 445.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513529), slot 1, text ID 65813479424 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513529), slot 2, text ID 65813544960 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513539), slot 1, text ID 65813610496 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513539), slot 3, text ID 65813676032 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513560), slot 1, text ID 65813741568 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513621), slot 1, text ID 65813807104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513682), slot 1, text ID 65813872640 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513682), slot 2, text ID 65813938176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513682), slot 3, text ID 65814003712 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513695), slot 1, text ID 65814069248 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513705), slot 1, text ID 65814134784 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513705), slot 2, text ID 65814200320 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513705), slot 4, text ID 65814265856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513718), slot 1, text ID 65814331392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513728), slot 1, text ID 65814396928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513728), slot 3, text ID 65814462464 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513728), slot 4, text ID 65814528000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513739), slot 1, text ID 65814593536 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513746), slot 1, text ID 65814659072 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513746), slot 2, text ID 65814724608 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513752), slot 1, text ID 65814790144 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513767), slot 1, text ID 65814855680 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513782), slot 1, text ID 65814921216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513782), slot 3, text ID 65814986752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513790), slot 1, text ID 65815052288 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513815), slot 1, text ID 65815117824 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 1, text ID 65815183360 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 2, text ID 65815248896 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 3, text ID 65815314432 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 5, text ID 65815379968 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513848), slot 1, text ID 65815445504 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513848), slot 2, text ID 65815511040 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513857), slot 1, text ID 65815576576 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513883), slot 1, text ID 65815642112 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513909), slot 1, text ID 65815707648 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513909), slot 3, text ID 65815773184 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513916), slot 1, text ID 65815838720 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513924), slot 1, text ID 65815904256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513932), slot 1, text ID 65815969792 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513932), slot 2, text ID 65816035328 is not referenced.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513942), slot 1, text ID 65816100864 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513964), slot 1, text ID 65816166400 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513986), slot 1, text ID 65816231936 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513986), slot 3, text ID 65816297472 is not referenced.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
There are 16163 rows in 1360 pages for object 'SUH_NORMAS'.
CHECKDB found 0 allocation errors and 46 consistency errors in table
'SUH_NORMAS' (object ID 1806681534).
DBCC results for '_SUB_ENTIDAD'.
There are 288 rows in 5 pages for object '_SUB_ENTIDAD'.
DBCC results for 'SUT_JURISPRUDENCIA'.
There are 0 rows in 0 pages for object 'SUT_JURISPRUDENCIA'.
DBCC results for 'SUB_DESCRIPTOR_TEMATICO'.
There are 3569 rows in 67 pages for object 'SUB_DESCRIPTOR_TEMATICO'.
DBCC results for 'SUB_ESTADO_NORMA'.
There are 6 rows in 1 pages for object 'SUB_ESTADO_NORMA'.
DBCC results for 'SUH_APARTES_REGLAMENTA'.
There are 0 rows in 1 pages for object 'SUH_APARTES_REGLAMENTA'.
DBCC results for 'dtproperties'.
There are 42 rows in 1 pages for object 'dtproperties'.
DBCC results for 'SUH_JURISPRUDENCIA'.
There are 4170 rows in 102 pages for object 'SUH_JURISPRUDENCIA'.
DBCC results for 'SUB_ENTIDAD_PUBLICA'.
There are 307 rows in 5 pages for object 'SUB_ENTIDAD_PUBLICA'.
DBCC results for 'DOB_ACTUACION_PROCESAL'.
There are 3 rows in 1 pages for object 'DOB_ACTUACION_PROCESAL'.
CHECKDB found 0 allocation errors and 46 consistency errors in database
'SIDOJ'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (SIDOJ repair_fast).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.


Y ahi que se puede hacer?
Gracias!


"Javier Loria" wrote:

Hola Alejo:
Significa que hay una problema de consistencia en tu base de datos.
Este
problema se produce con frecuencia por problemas con el disco duro donde
esta almacenada la bd.
Ejecuta el comando:
DBCC CHECKDB ('SIDOJ', REPAIR_FAST)
o mejor todavia:
DBCC CHECKDB ('SIDOJ', REPAIR_REBUILD )
Este deberia reparar el problema, y luego de correrlo te recomiendo
que
hagar un respaldo de la BD por si acaso te sigue dando problema el disco.
Saludos,

Javier Loria
Costa Rica-MVP
Solid Quality Learning
"AlejoR" wrote in message
news:
> Que tal grupo.
> Hice un chequeo de la base de datos y me arroja este mensaje!
> No entiendo mucho de lo que significa,, un help para solucionarlo.
>
> El problema es que varias consultas estan sacando error!
> SQLSERVER 2000 SP4
>
> DBCC CHECKDB with PHYSICAL_ONLY
>
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 1806681534, index ID 0: Page (1:511558) could not be
> processed.
> See other errors for details.
> Server: Msg 8944, Level 16, State 1, Line 1
> Table error: Object ID 1806681534, index ID 0, page (1:511558), row 1.
> Test
> (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed.
> Values
> are 653 and 445.
> DBCC results for 'SIDOJ'.
> There are 0 rows in 0 pages for object 'SUH_NORMAS'.
> CHECKDB found 0 allocation errors and 2 consistency errors in table
> 'SUH_NORMAS' (object ID 1806681534).
> CHECKDB found 0 allocation errors and 2 consistency errors in database
> 'SIDOJ'.
> repair_allow_data_loss is the minimum repair level for the errors found
> by
> DBCC CHECKDB (SIDOJ ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>

Que tal Javier,
Si al hacer el chequeo con REPAIR_REBUILD sale exactamente lo mismo, es
sintoma que no hay nada que hacer?
Gracias


"Javier Loria" escribió en el mensaje
news:%

Hola Alejo:
Ya se hicieron algunas correcciones con el comando, pero quedaron
algunas pendientes, prueba ahora con: DBCC CHECKDB ('SIDOJ',
REPAIR_REBUILD ) que es mas exaustivo.
Saludos


Javier Loria
Costa Rica-MVP
Solid Quality Learning

"AlejoR" wrote in message
news:

Esto es lo que salio al hacer el chequeo

dbcc checkdb ('SIDOJ', REPAIR_FAST)

DBCC results for 'DOB_ESTADO_DEL_PROCESO'.
There are 3 rows in 1 pages for object 'DOB_ESTADO_DEL_PROCESO'.
DBCC results for 'SUH_NORMAS'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1806681534, index ID 0: Page (1:511558) could not be processed.
See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1806681534, index ID 0, page (1:511558), row 1.
Test
(columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed.
Values
are 653 and 445.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513529), slot 1, text ID 65813479424 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513529), slot 2, text ID 65813544960 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513539), slot 1, text ID 65813610496 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513539), slot 3, text ID 65813676032 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513560), slot 1, text ID 65813741568 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513621), slot 1, text ID 65813807104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513682), slot 1, text ID 65813872640 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513682), slot 2, text ID 65813938176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513682), slot 3, text ID 65814003712 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513695), slot 1, text ID 65814069248 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513705), slot 1, text ID 65814134784 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513705), slot 2, text ID 65814200320 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513705), slot 4, text ID 65814265856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513718), slot 1, text ID 65814331392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513728), slot 1, text ID 65814396928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513728), slot 3, text ID 65814462464 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513728), slot 4, text ID 65814528000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513739), slot 1, text ID 65814593536 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513746), slot 1, text ID 65814659072 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513746), slot 2, text ID 65814724608 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513752), slot 1, text ID 65814790144 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513767), slot 1, text ID 65814855680 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513782), slot 1, text ID 65814921216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513782), slot 3, text ID 65814986752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513790), slot 1, text ID 65815052288 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513815), slot 1, text ID 65815117824 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 1, text ID 65815183360 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 2, text ID 65815248896 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 3, text ID 65815314432 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513840), slot 5, text ID 65815379968 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513848), slot 1, text ID 65815445504 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513848), slot 2, text ID 65815511040 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513857), slot 1, text ID 65815576576 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513883), slot 1, text ID 65815642112 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513909), slot 1, text ID 65815707648 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513909), slot 3, text ID 65815773184 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513916), slot 1, text ID 65815838720 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513924), slot 1, text ID 65815904256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513932), slot 1, text ID 65815969792 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513932), slot 2, text ID 65816035328 is not referenced.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513942), slot 1, text ID 65816100864 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513964), slot 1, text ID 65816166400 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513986), slot 1, text ID 65816231936 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1806681534. The text, ntext, or image node at page
(1:513986), slot 3, text ID 65816297472 is not referenced.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
There are 16163 rows in 1360 pages for object 'SUH_NORMAS'.
CHECKDB found 0 allocation errors and 46 consistency errors in table
'SUH_NORMAS' (object ID 1806681534).
DBCC results for '_SUB_ENTIDAD'.
There are 288 rows in 5 pages for object '_SUB_ENTIDAD'.
DBCC results for 'SUT_JURISPRUDENCIA'.
There are 0 rows in 0 pages for object 'SUT_JURISPRUDENCIA'.
DBCC results for 'SUB_DESCRIPTOR_TEMATICO'.
There are 3569 rows in 67 pages for object 'SUB_DESCRIPTOR_TEMATICO'.
DBCC results for 'SUB_ESTADO_NORMA'.
There are 6 rows in 1 pages for object 'SUB_ESTADO_NORMA'.
DBCC results for 'SUH_APARTES_REGLAMENTA'.
There are 0 rows in 1 pages for object 'SUH_APARTES_REGLAMENTA'.
DBCC results for 'dtproperties'.
There are 42 rows in 1 pages for object 'dtproperties'.
DBCC results for 'SUH_JURISPRUDENCIA'.
There are 4170 rows in 102 pages for object 'SUH_JURISPRUDENCIA'.
DBCC results for 'SUB_ENTIDAD_PUBLICA'.
There are 307 rows in 5 pages for object 'SUB_ENTIDAD_PUBLICA'.
DBCC results for 'DOB_ACTUACION_PROCESAL'.
There are 3 rows in 1 pages for object 'DOB_ACTUACION_PROCESAL'.
CHECKDB found 0 allocation errors and 46 consistency errors in database
'SIDOJ'.
repair_allow_data_loss is the minimum repair level for the errors found
by
DBCC CHECKDB (SIDOJ repair_fast).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.


Y ahi que se puede hacer?
Gracias!


"Javier Loria" wrote:

Hola Alejo:
Significa que hay una problema de consistencia en tu base de datos.
Este
problema se produce con frecuencia por problemas con el disco duro donde
esta almacenada la bd.
Ejecuta el comando:
DBCC CHECKDB ('SIDOJ', REPAIR_FAST)
o mejor todavia:
DBCC CHECKDB ('SIDOJ', REPAIR_REBUILD )
Este deberia reparar el problema, y luego de correrlo te recomiendo
que
hagar un respaldo de la BD por si acaso te sigue dando problema el
disco.
Saludos,

Javier Loria
Costa Rica-MVP
Solid Quality Learning
"AlejoR" wrote in message
news:
> Que tal grupo.
> Hice un chequeo de la base de datos y me arroja este mensaje!
> No entiendo mucho de lo que significa,, un help para solucionarlo.
>
> El problema es que varias consultas estan sacando error!
> SQLSERVER 2000 SP4
>
> DBCC CHECKDB with PHYSICAL_ONLY
>
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 1806681534, index ID 0: Page (1:511558) could not be
> processed.
> See other errors for details.
> Server: Msg 8944, Level 16, State 1, Line 1
> Table error: Object ID 1806681534, index ID 0, page (1:511558), row 1.
> Test
> (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed.
> Values
> are 653 and 445.
> DBCC results for 'SIDOJ'.
> There are 0 rows in 0 pages for object 'SUH_NORMAS'.
> CHECKDB found 0 allocation errors and 2 consistency errors in table
> 'SUH_NORMAS' (object ID 1806681534).
> CHECKDB found 0 allocation errors and 2 consistency errors in database
> 'SIDOJ'.
> repair_allow_data_loss is the minimum repair level for the errors
> found by
> DBCC CHECKDB (SIDOJ ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>