none
Erro no teste de integridade RRS feed

  • Pergunta

  • Pessoal, ao executar a rotina de checar a integridade apareceu o seguinte resultado,

    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near 'RH_HOMOLOGACAO'.
    Msg 319, Level 15, State 1, Line 1
    Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

    Executei o seguinte script,

    GO
    USE [RH_HOMOLOGACAO]
    GO
    DBCC CHECKDB(N''RH_HOMOLOGACAO'')  WITH NO_INFOMSGS

    GO

    O que pode ser ?

    Grato



    Bruno Avanso


    • Editado Bruno Avanso terça-feira, 18 de fevereiro de 2014 15:21
    terça-feira, 18 de fevereiro de 2014 15:21

Respostas

  • oi Bruno,

    Eu recomendo nesses casos que você restaure um backup anterior da base de dados e faça uma verificação dos discos aonde esse banco de dados está armazenado. Alguns dos erros no log são apenas indices corrompidos e poderiam ser resolvidos sem perder dados, mas diversos outros erros são inconsistencias de dados, chaves estrangeiras que não estão sendo respeitadas que vai fazer com que você perca dados se tentar arrumar os erros com o DBCC CHECKDB... 

    Aconselho tambem que você leia a documentação do DBCC CHECKDB no seguinte link: http://technet.microsoft.com/pt-br/library/ms176064.aspx 

    Nele há explicações do que aconteceu, como interpretar esses erros, como resolver eles (perdendo dados) e inclusive a mesma recomendaçao que acabei de dar de restaurar um backup anterior se quiser evitar de perder informações.

    abraços e boa sorte


    Felipe Ferreira - @SQLBoy SQL Server MVP | SolidQ Mentor | Friends of RedGate http://www.templar.com.br/blogs/felipe

    terça-feira, 18 de fevereiro de 2014 16:08

Todas as Respostas

  • Se o comando que você executou foi exatamente esse então tem aspas a mais no nome do banco... tem 2 aspas, o nome do banco e mais duas aspas... o correto é apenas 'RH_HOMOLOGACAO' ou, no caso do CHECKDB, nem é necessário as aspas... só DBCC CHECKDB(RH_HOMOLOGACAO)  WITH NO_INFOMSGS deve funcionar.

    att.


    Felipe Ferreira - @SQLBoy SQL Server MVP | SolidQ Mentor | Friends of RedGate http://www.templar.com.br/blogs/felipe

    terça-feira, 18 de fevereiro de 2014 15:35
  • Retornou mesmo erro,

    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near 'RH_HOMOLOGACAO'.
    Msg 319, Level 15, State 1, Line 1
    Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

    A query ficou asism,

    CHECKDB(RH_HOMOLOGACAO)  WITH NO_INFOMSGS


    Bruno Avanso

    terça-feira, 18 de fevereiro de 2014 15:39
  • agora faltou o DBCC :)

    DBCC CHECKDB(RH_HOMOLOGACAO)  WITH NO_INFOMSGS



    Felipe Ferreira - @SQLBoy SQL Server MVP | SolidQ Mentor | Friends of RedGate http://www.templar.com.br/blogs/felipe

    terça-feira, 18 de fevereiro de 2014 15:42
  • Agora sim,

    Olha o resultado,

    Msg 8961, Level 16, State 1, Line 2
    Table error: Object ID 733961691, index ID 1, partition ID 72057769312780288, alloc unit ID 72057594129416192 (type LOB data). The off-row data node at page (1:38793), slot 14, text ID 252773466112 does not match its reference from page (1:454778), slot 19.
    Msg 8974, Level 16, State 1, Line 2
    Table error: Object ID 733961691, index ID 1, partition ID 72057769312780288, alloc unit ID 72057594129416192 (type LOB data). The off-row data node at page (1:38793), slot 14, text ID 0 is pointed to by page (1:253976), slot 11 and by page (1:454778), slot 19.
    Msg 8929, Level 16, State 1, Line 2
    Object ID 733961691, index ID 1, partition ID 72057769312780288, alloc unit ID 72057769385918464 (type In-row data): Errors found in off-row data with ID 252773466112 owned by data record identified by RID = (1:253976:11)
    Msg 8929, Level 16, State 1, Line 2
    Object ID 733961691, index ID 1, partition ID 72057769312780288, alloc unit ID 72057769385918464 (type In-row data): Errors found in off-row data with ID 251761590272 owned by data record identified by RID = (1:454778:19)
    Msg 8951, Level 16, State 1, Line 2
    Table error: table 'Z_PROCESSOS' (ID 733961691). Data row does not have a matching index row in the index 'AX_2438_6403' (ID 5). Possible missing or invalid keys for the index row matching:
    Msg 8955, Level 16, State 1, Line 2
    Data row (1:454778:19) identified by (HANDLE = 102216) with index values 'NOME = 'Totalizador' and HANDLE = 102216'.
    CHECKDB found 0 allocation errors and 5 consistency errors in table 'Z_PROCESSOS' (object ID 733961691).
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 2, text ID 252782706688 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 3, text ID 252782772224 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 4, text ID 252789850112 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 5, text ID 252789915648 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 6, text ID 252790964224 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 7, text ID 252791029760 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 8, text ID 252792209408 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 9, text ID 252792274944 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 10, text ID 252794175488 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 11, text ID 252794241024 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 12, text ID 252794372096 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6277), slot 13, text ID 252794437632 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6279), slot 1, text ID 251762311168 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:6279), slot 2, text ID 252823011328 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:9177), slot 17, text ID 252794568704 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:13755), slot 10, text ID 252794634240 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:13755), slot 11, text ID 252794765312 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:13755), slot 17, text ID 252794830848 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:13755), slot 18, text ID 252795027456 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:13755), slot 19, text ID 252795092992 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:13755), slot 21, text ID 252795289600 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:13755), slot 22, text ID 252795355136 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:13755), slot 23, text ID 252795486208 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:13755), slot 24, text ID 252795551744 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:16652), slot 25, text ID 252795682816 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18995), slot 33, text ID 251762507776 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 9, text ID 252795748352 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 10, text ID 252796010496 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 15, text ID 252796076032 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 16, text ID 252797124608 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 17, text ID 252797190144 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 18, text ID 252808986624 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 20, text ID 252809052160 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 21, text ID 252811214848 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 22, text ID 252811280384 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 23, text ID 252811935744 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 24, text ID 252812001280 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 25, text ID 252814295040 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 26, text ID 252814360576 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 27, text ID 252819537920 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:18998), slot 28, text ID 252819603456 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 1, text ID 252823076864 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 2, text ID 252823142400 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 3, text ID 252823207936 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 4, text ID 252823339008 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 5, text ID 252823404544 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 6, text ID 252823601152 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 7, text ID 252823666688 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 8, text ID 252823928832 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 9, text ID 252823994368 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 10, text ID 252832186368 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 11, text ID 252832251904 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 12, text ID 252836184064 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:19091), slot 13, text ID 252836249600 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:24525), slot 21, text ID 252821569536 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 21, text ID 252821635072 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 22, text ID 252821897216 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 23, text ID 252821962752 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 24, text ID 252822093824 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 25, text ID 252822159360 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 26, text ID 252822290432 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 27, text ID 252822355968 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 28, text ID 252822487040 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 29, text ID 252822552576 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 30, text ID 252822683648 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27073), slot 31, text ID 252822749184 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27079), slot 22, text ID 251763884032 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 23, text ID 251762704384 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 24, text ID 251762835456 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 25, text ID 251762900992 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 26, text ID 251763032064 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 27, text ID 251763097600 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 28, text ID 251763228672 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 29, text ID 251763294208 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 30, text ID 251763425280 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 31, text ID 251763490816 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 32, text ID 251763621888 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 33, text ID 251763687424 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:27175), slot 34, text ID 251763818496 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:41592), slot 26, text ID 251764015104 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:41592), slot 27, text ID 252838346752 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 60, text ID 252838412288 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 61, text ID 252838674432 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 62, text ID 252838739968 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 63, text ID 252839788544 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 64, text ID 252839854080 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 65, text ID 252845096960 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 66, text ID 252845162496 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 67, text ID 252886908928 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 68, text ID 252886974464 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 69, text ID 252887105536 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 70, text ID 252887171072 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:45751), slot 71, text ID 252887302144 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:46206), slot 40, text ID 251764080640 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:49449), slot 28, text ID 252887367680 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:55780), slot 49, text ID 252887498752 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:55780), slot 50, text ID 252887564288 is not referenced.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528248) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528249) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:528272), slot 0, text ID 251762311168 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:528273), slot 0, text ID 251762311168 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:528274), slot 0, text ID 251762311168 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:528275), slot 0, text ID 251762311168 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:528276), slot 0, text ID 251762311168 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:528277), slot 0, text ID 251762311168 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:528278), slot 0, text ID 251762311168 is not referenced.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data). The off-row data node at page (1:528279), slot 0, text ID 251762311168 is not referenced.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528280) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528281) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528282) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528283) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528284) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528285) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528286) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 2533, Level 16, State 1, Line 2
    Table error: page (1:528287) allocated to object ID 797961919, index ID 1, partition ID 72057769285320704, alloc unit ID 72057594129612800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
    Msg 8906, Level 16, State 1, Line 2
    Page (1:126667) in database ID 24 is allocated in the SGAM (1:3) and PFS (1:121320), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED   0_PCT_FULL'.
    CHECKDB found 1 allocation errors and 115 consistency errors in table 'Z_AGENDAMENTOLOG' (object ID 797961919).
    CHECKDB found 1 allocation errors and 120 consistency errors in database 'CORPORATIVO_HOMOLOGACAO'.
    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (CORPORATIVO_HOMOLOGACAO).

    O que posso fazer ?

    Grato

    Cláudio Bruno


    Bruno Avanso

    terça-feira, 18 de fevereiro de 2014 16:02
  • oi Bruno,

    Eu recomendo nesses casos que você restaure um backup anterior da base de dados e faça uma verificação dos discos aonde esse banco de dados está armazenado. Alguns dos erros no log são apenas indices corrompidos e poderiam ser resolvidos sem perder dados, mas diversos outros erros são inconsistencias de dados, chaves estrangeiras que não estão sendo respeitadas que vai fazer com que você perca dados se tentar arrumar os erros com o DBCC CHECKDB... 

    Aconselho tambem que você leia a documentação do DBCC CHECKDB no seguinte link: http://technet.microsoft.com/pt-br/library/ms176064.aspx 

    Nele há explicações do que aconteceu, como interpretar esses erros, como resolver eles (perdendo dados) e inclusive a mesma recomendaçao que acabei de dar de restaurar um backup anterior se quiser evitar de perder informações.

    abraços e boa sorte


    Felipe Ferreira - @SQLBoy SQL Server MVP | SolidQ Mentor | Friends of RedGate http://www.templar.com.br/blogs/felipe

    terça-feira, 18 de fevereiro de 2014 16:08
  • Bruno,

    A Felipe esta correto, mas uma possibilidade também pode ser aplicada, realizar um backup do seu ambiente, e posteriormente rodar o comando DBCC CheckDB() com a opção repair_allow_data_loss, conforme sugestão do próprio SQL Server.

    Mas este procedimento representa que possível dados podem ser perdidos, por isso é importante realizar o backup, se não quiser seguir este procedimento realize o que o Felipe destacou anteriormente.


    Pedro Antonio Galvão Junior [MVP | Microsoft Evangelist | Microsoft Partner | Engenheiro de Softwares | Especialista em Banco de Dados | SorBR.Net | Professor Universitário | MSIT.com]

    terça-feira, 18 de fevereiro de 2014 17:37
    Moderador
  • Bruno,

    A sintaxe do seu comando esta errada, tente assim:

    DBCC CHECKDB(N'RH_Homologacao')  WITH NO_INFOMSGS


    Pedro Antonio Galvão Junior [MVP | Microsoft Evangelist | Microsoft Partner | Engenheiro de Softwares | Especialista em Banco de Dados | SorBR.Net | Professor Universitário | MSIT.com]

    terça-feira, 18 de fevereiro de 2014 17:38
    Moderador