Home Forums SQL Server 2005 Administering Could not continue scan with NOLOCK due to data movement. RE: Could not continue scan with NOLOCK due to data movement.

  • ah ha, that was it ... good call.

    Msg 8928, Level 16, State 1, Line 1

    Object ID 1419152101, index ID 5, partition ID 72057594157858816, alloc unit ID 72057594172669952 (type In-row data): Page (1:17819) could not be processed. See other errors for details.

    Msg 8939, Level 16, State 98, Line 1

    Table error: Object ID 1419152101, index ID 5, partition ID 72057594157858816, alloc unit ID 72057594172669952 (type In-row data), page (1:17819). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.

    Msg 8928, Level 16, State 1, Line 1

    Object ID 1419152101, index ID 5, partition ID 72057594157858816, alloc unit ID 72057594172669952 (type In-row data): Page (1:17851) could not be processed. See other errors for details.

    Msg 8939, Level 16, State 98, Line 1

    Table error: Object ID 1419152101, index ID 5, partition ID 72057594157858816, alloc unit ID 72057594172669952 (type In-row data), page (1:17851). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29493257 and -4.

    Rebuilt my indexes and all is well.

    Thanks