• Alan.B (5/2/2016)


    terry999 (5/2/2016)


    Hi

    I got this error on a scheduled integrity check. SQL 2005 sp2

    Data row does not have a matching index row in the index '' (ID 2). Possible missing or invalid keys for the index row matching:

    The corrupted index is a non-clustered Unique index on a VIEW.

    I rebuild both the clustered index on the view and the corrupted index.

    It fixed the problem.

    I'm trying to find what caused the corruption.

    1. Windows Event viewer shows nothing

    2. SQL Error Log shows no error.

    I'm surprised the DB was not being used in the period it failed (weekend).

    Any ideas?

    Logging and the event viewer could shine some light on this but that depends on what's logged and for how long. Many things can cause corruption.

    As I've been explained, most of the times is the file system.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2