Error al modificar un indice

Hola Jesus, yo te diria que ejecutes el comando DBCC CHECKDB y verifiques
que no existan daños en la bdd


Salu2
Maxi


"Jesus" escribió en el mensaje
news:

Tengo una tabla en SQL 2000 q al intentar modificar el indice me da el
siguiente error:
No se puede modificar la tabla.
Error ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server]
No se pudo abrir FCB porque el Id. de archivo 14646 no es válido en la
base
de datos 'NOMBRE BASE DE DATOS'

EN el resto de las tablas no me sucede esto.

Muchas gracias por adelantado

Hola Maxi:
El sql 2000 esta con el SP3a.
He pasado el DBCC CHECKDB y al ejecucarlo aparece los siguiente ( he omitido
varias lineas similares):


Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3248) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3264) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3272) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3296) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3304) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3312) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3320) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3328) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3336) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8904, nivel 16, estado 1, línea 1
Extent (1:3344) in database ID 5 is allocated by more than one allocation
object.
Servidor: mensaje 8913, nivel 16, estado 1, línea 1
Extent (1:3344) is allocated to 'SGAM' and at least one other object.
Servidor: mensaje 8928, nivel 16, estado 1, línea 1
Object ID 0, index ID 0: Page (1:3348) could not be processed. See other
errors for details.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3360) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3376) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3392) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3400) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3408) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3416) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9232) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9240) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9248) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9256) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9264) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9272) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9424) in database ID 5 is marked allocated in the GAM, but no SGAM
or IAM has allocated it.
Servidor: mensaje 2575, nivel 16, estado 1, línea 1
IAM page (1:3354) is pointed to by the next pointer of IAM page (0:0) object
ID 478832968 index ID 9 but was not detected in the scan.
Servidor: mensaje 8906, nivel 16, estado 1, línea 1
Page (1:18075) in database ID 5 is allocated in the SGAM (1:3) and PFS
(1:16176), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Servidor: mensaje 2533, nivel 16, estado 1, línea 1
Table error: Page (1:2334) allocated to object ID 1010102639, index ID 2 was
not seen. Page may be invalid or have incorrect object ID information in its
header.
Servidor: mensaje 8976, nivel 16, estado 1, línea 1
Table error: Object ID 1010102639, index ID 2. Page (1:2334) was not seen in
the scan although its parent (1:1861) and previous (1:652) refer to it. Check
any previous errors.
Servidor: mensaje 8978, nivel 16, estado 1, línea 1
Table error: Object ID 1010102639, index ID 2. Page (1:3015) is missing a
reference from previous page (1:2334). Possible chain linkage problem.
Servidor: mensaje 8948, nivel 16, estado 1, línea 1
Database error: Page (1:3353) is marked with the wrong type in PFS page
(1:1). PFS status 0x0 expected 0x60.
Servidor: mensaje 8948, nivel 16, estado 1, línea 1
Database error: Page (1:3355) is marked with the wrong type in PFS page
(1:1). PFS status 0x0 expected 0x60.
Servidor: mensaje 8906, nivel 16, estado 1, línea 1
Page (1:650) in database ID 5 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Servidor: mensaje 2575, nivel 16, estado 1, línea 1
IAM page (1:2332) is pointed to by the next pointer of IAM page (0:0) object
ID 1237579447 index ID 0 but was not detected in the scan.
Servidor: mensaje 7965, nivel 16, estado 1, línea 1
Table error: Could not check object ID 1237579447, index ID 1 due to invalid
allocation (IAM) page(s).
Servidor: mensaje 8946, nivel 16, estado 1, línea 1
Table error: Allocation page (1:2332) has invalid IAM_PAGE page header
values. Type is 1. Check type, object ID and page ID on the page.
Servidor: mensaje 8906, nivel 16, estado 1, línea 1
Page (1:2357) in database ID 5 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Servidor: mensaje 8948, nivel 16, estado 1, línea 1

Luego aparecen varis tablas, la q me da problemas pone:

DBCC results for 'tabla'.
There are 0 rows in 0 pages for object tabla'.
CHECKDB found 1 allocation errors and 2 consistency errors in table
'tabla'(object ID 1381736125).

Y termina con :

CHECKDB found 37 allocation errors and 71 consistency errors in database
'Pruebas'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (Pruebas).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Jesus, revisa la sintaxis del DBCC y veras que tiene unos swith para poder
reparar la base de datos. Te recomiendo que lo ejecutes


Salu2
Maxi


"Jesus" escribió en el mensaje
news:

Hola Maxi:
El sql 2000 esta con el SP3a.
He pasado el DBCC CHECKDB y al ejecucarlo aparece los siguiente ( he
omitido
varias lineas similares):


Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3248) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3264) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3272) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3296) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3304) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3312) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3320) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3328) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3336) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8904, nivel 16, estado 1, línea 1
Extent (1:3344) in database ID 5 is allocated by more than one allocation
object.
Servidor: mensaje 8913, nivel 16, estado 1, línea 1
Extent (1:3344) is allocated to 'SGAM' and at least one other object.
Servidor: mensaje 8928, nivel 16, estado 1, línea 1
Object ID 0, index ID 0: Page (1:3348) could not be processed. See other
errors for details.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3360) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3376) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3392) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3400) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3408) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:3416) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9232) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9240) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9248) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9256) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9264) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9272) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 8905, nivel 16, estado 1, línea 1
Extent (1:9424) in database ID 5 is marked allocated in the GAM, but no
SGAM
or IAM has allocated it.
Servidor: mensaje 2575, nivel 16, estado 1, línea 1
IAM page (1:3354) is pointed to by the next pointer of IAM page (0:0)
object
ID 478832968 index ID 9 but was not detected in the scan.
Servidor: mensaje 8906, nivel 16, estado 1, línea 1
Page (1:18075) in database ID 5 is allocated in the SGAM (1:3) and PFS
(1:16176), but was not allocated in any IAM. PFS flags 'MIXED_EXT
ALLOCATED
0_PCT_FULL'.
Servidor: mensaje 2533, nivel 16, estado 1, línea 1
Table error: Page (1:2334) allocated to object ID 1010102639, index ID 2
was
not seen. Page may be invalid or have incorrect object ID information in
its
header.
Servidor: mensaje 8976, nivel 16, estado 1, línea 1
Table error: Object ID 1010102639, index ID 2. Page (1:2334) was not seen
in
the scan although its parent (1:1861) and previous (1:652) refer to it.
Check
any previous errors.
Servidor: mensaje 8978, nivel 16, estado 1, línea 1
Table error: Object ID 1010102639, index ID 2. Page (1:3015) is missing a
reference from previous page (1:2334). Possible chain linkage problem.
Servidor: mensaje 8948, nivel 16, estado 1, línea 1
Database error: Page (1:3353) is marked with the wrong type in PFS page
(1:1). PFS status 0x0 expected 0x60.
Servidor: mensaje 8948, nivel 16, estado 1, línea 1
Database error: Page (1:3355) is marked with the wrong type in PFS page
(1:1). PFS status 0x0 expected 0x60.
Servidor: mensaje 8906, nivel 16, estado 1, línea 1
Page (1:650) in database ID 5 is allocated in the SGAM (1:3) and PFS
(1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Servidor: mensaje 2575, nivel 16, estado 1, línea 1
IAM page (1:2332) is pointed to by the next pointer of IAM page (0:0)
object
ID 1237579447 index ID 0 but was not detected in the scan.
Servidor: mensaje 7965, nivel 16, estado 1, línea 1
Table error: Could not check object ID 1237579447, index ID 1 due to
invalid
allocation (IAM) page(s).
Servidor: mensaje 8946, nivel 16, estado 1, línea 1
Table error: Allocation page (1:2332) has invalid IAM_PAGE page header
values. Type is 1. Check type, object ID and page ID on the page.
Servidor: mensaje 8906, nivel 16, estado 1, línea 1
Page (1:2357) in database ID 5 is allocated in the SGAM (1:3) and PFS
(1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Servidor: mensaje 8948, nivel 16, estado 1, línea 1

Luego aparecen varis tablas, la q me da problemas pone:

DBCC results for 'tabla'.
There are 0 rows in 0 pages for object tabla'.
CHECKDB found 1 allocation errors and 2 consistency errors in table
'tabla'(object ID 1381736125).

Y termina con :

CHECKDB found 37 allocation errors and 71 consistency errors in database
'Pruebas'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (Pruebas).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Hola de nuevo:
He probado con la opcion repair_allow_data_loss q parece ser la unica q
permite reparar totalmente los errores y parece ser q se ha solucionado sin
perder ningun dato.
Ha terminado con:
CHECKDB found 37 allocation errors and 147 consistency errors in database
'Pruebas'.
CHECKDB fixed 37 allocation errors and 147 consistency errors in database
'Pruebas'.

Hay alguna causa por la q se haya corrompido al base de datos de un dia para
otro????

Un saludo

"Maxi" wrote:

Jesus, revisa la sintaxis del DBCC y veras que tiene unos swith para poder
reparar la base de datos. Te recomiendo que lo ejecutes


Salu2
Maxi


"Jesus" escribió en el mensaje
news:
> Hola Maxi:
> El sql 2000 esta con el SP3a.
> He pasado el DBCC CHECKDB y al ejecucarlo aparece los siguiente ( he
> omitido
> varias lineas similares):
>
>
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3248) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3264) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3272) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3296) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3304) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3312) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3320) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3328) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3336) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8904, nivel 16, estado 1, línea 1
> Extent (1:3344) in database ID 5 is allocated by more than one allocation
> object.
> Servidor: mensaje 8913, nivel 16, estado 1, línea 1
> Extent (1:3344) is allocated to 'SGAM' and at least one other object.
> Servidor: mensaje 8928, nivel 16, estado 1, línea 1
> Object ID 0, index ID 0: Page (1:3348) could not be processed. See other
> errors for details.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3360) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3376) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3392) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3400) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3408) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3416) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9232) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9240) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9248) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9256) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9264) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9272) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9424) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 2575, nivel 16, estado 1, línea 1
> IAM page (1:3354) is pointed to by the next pointer of IAM page (0:0)
> object
> ID 478832968 index ID 9 but was not detected in the scan.
> Servidor: mensaje 8906, nivel 16, estado 1, línea 1
> Page (1:18075) in database ID 5 is allocated in the SGAM (1:3) and PFS
> (1:16176), but was not allocated in any IAM. PFS flags 'MIXED_EXT
> ALLOCATED
> 0_PCT_FULL'.
> Servidor: mensaje 2533, nivel 16, estado 1, línea 1
> Table error: Page (1:2334) allocated to object ID 1010102639, index ID 2
> was
> not seen. Page may be invalid or have incorrect object ID information in
> its
> header.
> Servidor: mensaje 8976, nivel 16, estado 1, línea 1
> Table error: Object ID 1010102639, index ID 2. Page (1:2334) was not seen
> in
> the scan although its parent (1:1861) and previous (1:652) refer to it.
> Check
> any previous errors.
> Servidor: mensaje 8978, nivel 16, estado 1, línea 1
> Table error: Object ID 1010102639, index ID 2. Page (1:3015) is missing a
> reference from previous page (1:2334). Possible chain linkage problem.
> Servidor: mensaje 8948, nivel 16, estado 1, línea 1
> Database error: Page (1:3353) is marked with the wrong type in PFS page
> (1:1). PFS status 0x0 expected 0x60.
> Servidor: mensaje 8948, nivel 16, estado 1, línea 1
> Database error: Page (1:3355) is marked with the wrong type in PFS page
> (1:1). PFS status 0x0 expected 0x60.
> Servidor: mensaje 8906, nivel 16, estado 1, línea 1
> Page (1:650) in database ID 5 is allocated in the SGAM (1:3) and PFS
> (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Servidor: mensaje 2575, nivel 16, estado 1, línea 1
> IAM page (1:2332) is pointed to by the next pointer of IAM page (0:0)
> object
> ID 1237579447 index ID 0 but was not detected in the scan.
> Servidor: mensaje 7965, nivel 16, estado 1, línea 1
> Table error: Could not check object ID 1237579447, index ID 1 due to
> invalid
> allocation (IAM) page(s).
> Servidor: mensaje 8946, nivel 16, estado 1, línea 1
> Table error: Allocation page (1:2332) has invalid IAM_PAGE page header
> values. Type is 1. Check type, object ID and page ID on the page.
> Servidor: mensaje 8906, nivel 16, estado 1, línea 1
> Page (1:2357) in database ID 5 is allocated in the SGAM (1:3) and PFS
> (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Servidor: mensaje 8948, nivel 16, estado 1, línea 1
>
> Luego aparecen varis tablas, la q me da problemas pone:
>
> DBCC results for 'tabla'.
> There are 0 rows in 0 pages for object tabla'.
> CHECKDB found 1 allocation errors and 2 consistency errors in table
> 'tabla'(object ID 1381736125).
>
> Y termina con :
>
> CHECKDB found 37 allocation errors and 71 consistency errors in database
> 'Pruebas'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKDB (Pruebas).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
>

Hola, puede ser algun problema de HW quizas. Yo que vos revisaria como esta
el HW


Salu2
Maxi


"Jesus" escribió en el mensaje
news:

Hola de nuevo:
He probado con la opcion repair_allow_data_loss q parece ser la unica q
permite reparar totalmente los errores y parece ser q se ha solucionado
sin
perder ningun dato.
Ha terminado con:
CHECKDB found 37 allocation errors and 147 consistency errors in database
'Pruebas'.
CHECKDB fixed 37 allocation errors and 147 consistency errors in database
'Pruebas'.

Hay alguna causa por la q se haya corrompido al base de datos de un dia
para
otro????

Un saludo

"Maxi" wrote:

Jesus, revisa la sintaxis del DBCC y veras que tiene unos swith para
poder
reparar la base de datos. Te recomiendo que lo ejecutes


Salu2
Maxi


"Jesus" escribió en el mensaje
news:
> Hola Maxi:
> El sql 2000 esta con el SP3a.
> He pasado el DBCC CHECKDB y al ejecucarlo aparece los siguiente ( he
> omitido
> varias lineas similares):
>
>
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3248) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3264) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3272) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3296) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3304) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3312) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3320) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3328) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3336) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8904, nivel 16, estado 1, línea 1
> Extent (1:3344) in database ID 5 is allocated by more than one
> allocation
> object.
> Servidor: mensaje 8913, nivel 16, estado 1, línea 1
> Extent (1:3344) is allocated to 'SGAM' and at least one other object.
> Servidor: mensaje 8928, nivel 16, estado 1, línea 1
> Object ID 0, index ID 0: Page (1:3348) could not be processed. See
> other
> errors for details.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3360) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3376) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3392) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3400) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3408) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:3416) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9232) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9240) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9248) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9256) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9264) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9272) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 8905, nivel 16, estado 1, línea 1
> Extent (1:9424) in database ID 5 is marked allocated in the GAM, but no
> SGAM
> or IAM has allocated it.
> Servidor: mensaje 2575, nivel 16, estado 1, línea 1
> IAM page (1:3354) is pointed to by the next pointer of IAM page (0:0)
> object
> ID 478832968 index ID 9 but was not detected in the scan.
> Servidor: mensaje 8906, nivel 16, estado 1, línea 1
> Page (1:18075) in database ID 5 is allocated in the SGAM (1:3) and PFS
> (1:16176), but was not allocated in any IAM. PFS flags 'MIXED_EXT
> ALLOCATED
> 0_PCT_FULL'.
> Servidor: mensaje 2533, nivel 16, estado 1, línea 1
> Table error: Page (1:2334) allocated to object ID 1010102639, index ID
> 2
> was
> not seen. Page may be invalid or have incorrect object ID information
> in
> its
> header.
> Servidor: mensaje 8976, nivel 16, estado 1, línea 1
> Table error: Object ID 1010102639, index ID 2. Page (1:2334) was not
> seen
> in
> the scan although its parent (1:1861) and previous (1:652) refer to it.
> Check
> any previous errors.
> Servidor: mensaje 8978, nivel 16, estado 1, línea 1
> Table error: Object ID 1010102639, index ID 2. Page (1:3015) is missing
> a
> reference from previous page (1:2334). Possible chain linkage problem.
> Servidor: mensaje 8948, nivel 16, estado 1, línea 1
> Database error: Page (1:3353) is marked with the wrong type in PFS page
> (1:1). PFS status 0x0 expected 0x60.
> Servidor: mensaje 8948, nivel 16, estado 1, línea 1
> Database error: Page (1:3355) is marked with the wrong type in PFS page
> (1:1). PFS status 0x0 expected 0x60.
> Servidor: mensaje 8906, nivel 16, estado 1, línea 1
> Page (1:650) in database ID 5 is allocated in the SGAM (1:3) and PFS
> (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Servidor: mensaje 2575, nivel 16, estado 1, línea 1
> IAM page (1:2332) is pointed to by the next pointer of IAM page (0:0)
> object
> ID 1237579447 index ID 0 but was not detected in the scan.
> Servidor: mensaje 7965, nivel 16, estado 1, línea 1
> Table error: Could not check object ID 1237579447, index ID 1 due to
> invalid
> allocation (IAM) page(s).
> Servidor: mensaje 8946, nivel 16, estado 1, línea 1
> Table error: Allocation page (1:2332) has invalid IAM_PAGE page header
> values. Type is 1. Check type, object ID and page ID on the page.
> Servidor: mensaje 8906, nivel 16, estado 1, línea 1
> Page (1:2357) in database ID 5 is allocated in the SGAM (1:3) and PFS
> (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Servidor: mensaje 8948, nivel 16, estado 1, línea 1
>
> Luego aparecen varis tablas, la q me da problemas pone:
>
> DBCC results for 'tabla'.
> There are 0 rows in 0 pages for object tabla'.
> CHECKDB found 1 allocation errors and 2 consistency errors in table
> 'tabla'(object ID 1381736125).
>
> Y termina con :
>
> CHECKDB found 37 allocation errors and 71 consistency errors in
> database
> 'Pruebas'.
> repair_allow_data_loss is the minimum repair level for the errors found
> by
> DBCC CHECKDB (Pruebas).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
>