DBCC CHECKDB with PHYSICAL_ONLY

12/10/2006 - 23:53 por AlejoR | Informe spam
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.
 

Leer las respuestas

#1 Maxi
13/10/2006 - 02:14 | Informe spam
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.

Preguntas similares