Hi,
I try to repair DB that is in state Emergency Mode, but=20
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=20
(1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecuci=F3n de DBCC completada. Si hay mensajes de error,=20
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 pgina
(1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecucin de DBCC completada. Si hay mensajes de error,
consulte al
administrador del sistema.
How do i for repair the DB?
Than'ksql
No comments:
Post a Comment