SQL 2005 integrity check job failed

  • In one sql 2005 with sp2 X64, integrity check job failed with the following error:

    Process ID 58 attempted to unlock a resource it does not own: OBJECT: 2:127727253:0 . Retry the transaction, because this error may be caused by a timing condition

    The job failed in the last few weeks (it is a weekly job). It successed sometimes if I reran it, but It failed a few times last week when I reran the job.

  • Does this apply?

    http://support.microsoft.com/kb/933265

    The Redneck DBA

  • Thanks, Jason, I am not sure. That one occurs when you run insert statement, but I did not run the insert, just integrity check.

    It may apply.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply