Thursday, March 29, 2012

Error repair DB with dbcc checkdb

Hi,
I try to repair DB that is in state Emergency Mode, but execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la p=E1gina (1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecuci=F3n de DBCC completada. Si hay mensajes de error, consulte al
administrador del sistema.
How do i for repair the DB?
Than'kFrom Google translation page:
A latch in the page (1:177) with the type of latch SH. Error in sysindexes
cannot be read and be established.
(Pretty good translation actually)
One of the pages in the leaf level of the sysindexes clustered index is
corrupt. This error cannot be repaired so you'll have to revert to your
disaster recovery strategy. I recommend you call Product Support to help you
out. (http://support.microsoft.com)
Regards
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ivan Alexander Laverde" <anonymous@.discussions.microsoft.com> wrote in
message news:104c001c43f4c$d6aaaaf0$a101280a@.phx.gbl...
Hi,
I try to repair DB that is in state Emergency Mode, but
execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la página
(1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecución de DBCC completada. Si hay mensajes de error,
consulte al
administrador del sistema.
How do i for repair the DB?
Than'k

No comments:

Post a Comment