Boa tarde a todos.
Rodei um DBCC CHECKDB em um banco e recebi mensagem que existe um erro na tabela SYSINDEXES.
Como proceder o reparo neste caso? É possível só rodar o repair com "repair_allow_data_loss" conforme informado no final dos displays ou é o caso de fazer o restore do banco?
Obrigado,
Paulo Vilhena
==========================================================
Server: Msg 8966, Level 16, State 1, Line 1952636710
Could not read and latch page (1:533) with latch type SH. sysindexes failed.
Server: Msg 2598, Level 16, State 1, Line 1952636710
Clustered indexes on sysobjects and sysindexes cannot be re-created.
Server: Msg 8939, Level 16, State 1, Line 1952636710
Table Corrupt: Object ID 2, index ID 0, page (1:533). Test (m_freeCnt == freeCnt) failed. Values are 3928 and 4116.
Server: Msg 8945, Level 16, State 1, Line 1952636710
Table Corrupt: Object ID 2, index ID 1 will be rebuilt.
The error has been repaired.
The error has been repaired.
Clustered index successfully restored for object 'dbo.sysindexes' in database 'ONETOONE'.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'sysindexes' (object ID 2).
CHECKTABLE fixed 0 allocation errors and 1 consistency errors in table 'sysindexes' (object ID 2).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Server: Msg 8966, Level 16, State 1, Line 3
Could not read and latch page (1:533) with latch type SH. sysindexes failed.
Server: Msg 8939, Level 16, State 1, Line 3
Table Corrupt: Object ID 2, index ID 0, page (1:533). Test (m_freeCnt == freeCnt) failed. Values are 3928 and 4116.
DBCC results for 'ONETOONE'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysindexes' (object ID 2).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'ONETOONE'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (ONETOONE ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
