indice nonclustered

Casos do Dia a Dia – Corrupção Banco de Dados – Índice Nonclustered

Fala pessoal, No post de hoje, vou explicar como você pode analisar e resolver um problema de corrupção de dados em um índice nonclustered. #gogogo

Msg 8951, Level 16, State 1, Line 1
Table error: table 'NomeTabela' (ID XXXX). Data row does not have a matching index row in the index 'NomeIndice' (ID YYYY). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 1
Data row (Z:ZZZZZ:ZZ) identified by (NomeColuna1 = valor1) with index value '...'

CHECKDB found 0 allocation errors and 2 consistency errors in table 'NomeTabela' (object ID XXXX).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Msg 8951, Level 16, State 1, Line 1

Table error: table 'NomeTabela' (ID XXXX). Data row does not have a matching index row in the index 'NomeIndice' (ID YYYY). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 1

Data row (Z:ZZZZZ:ZZ) identified by (NomeColuna1 = valor1) with index value '...'

CHECKDB found 0 allocation errors and 2 consistency errors in table 'NomeTabela' (object ID XXXX).

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Alerta Corrupção de Dados: …

Tag: indice nonclustered