Home Forums SQL Server 2005 Data Corruption dbcc allow data lose problem with increasing log RE: dbcc allow data lose problem with increasing log

  • October 28, 2008 at 2:22 am

    #890432

    lyletan (10/27/2008)

    Hi Gail

    The message is:

    Could not continue scan with NOLOCK due to data movement.

    Server: Msg 601, Level 12, State 1, Line 1

    Could not continue scan with NOLOCK due to data movement.

    Server: Msg 601, Level 12, State 1, Line 1

    Could not continue scan with NOLOCK due to data movement.

    Server: Msg 601, Level 12, State 1, Line 1

    Could not continue scan with NOLOCK due to data movement.

    Server: Msg 601, Level 12, State 1, Line 1

    Thanks

    Vincent

    I meant the corruption errors that made you decide to run checkDB in the first place. Same command as Paul's asking for.

    Will be more specific next time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass