Error: 625, Severity: 20, State: 3

We have this in sql error log.
spid 66, Getrow: rowoffset entry 35(0) out of range (pg (0x3:0x1ba53c), obj
0x6df7358c, db 11, stat b)
Cannot retrieve row from page (35:1811772) by RID because the slotid
(1699164968) is not valid..
Error: 625, Severity: 20, State: 3
Any idea.. what to check? or we can ignore it?
--soonyulook like you have database corruption. run dbcc checkdb to get the report.
it's best if you restore the database from a known good backup. if you do
not have a backup, contact ms support to have them walk you through
recovering (with some loss of data, more than likely).
--
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:31898E05-D2F6-4E77-A310-0F032255F2E7@.microsoft.com...
> We have this in sql error log.
> spid 66, Getrow: rowoffset entry 35(0) out of range (pg (0x3:0x1ba53c),
> obj
> 0x6df7358c, db 11, stat b)
> Cannot retrieve row from page (35:1811772) by RID because the slotid
> (1699164968) is not valid..
> Error: 625, Severity: 20, State: 3
> Any idea.. what to check? or we can ignore it?
> --soonyu|||how we know this is from which table or which index?
35:1811772
is that possible know from dbcc page. and what parameter should i put.
soonyu
"oj" wrote:
> look like you have database corruption. run dbcc checkdb to get the report.
> it's best if you restore the database from a known good backup. if you do
> not have a backup, contact ms support to have them walk you through
> recovering (with some loss of data, more than likely).
> --
> -oj
>
> "soonyu" <soonyu@.discussions.microsoft.com> wrote in message
> news:31898E05-D2F6-4E77-A310-0F032255F2E7@.microsoft.com...
> > We have this in sql error log.
> > spid 66, Getrow: rowoffset entry 35(0) out of range (pg (0x3:0x1ba53c),
> > obj
> > 0x6df7358c, db 11, stat b)
> > Cannot retrieve row from page (35:1811772) by RID because the slotid
> > (1699164968) is not valid..
> > Error: 625, Severity: 20, State: 3
> >
> > Any idea.. what to check? or we can ignore it?
> >
> > --soonyu
>
>|||run the 'dbcc checkdb(11)' first to see if there is any error report.
also, please update your sql2k to sp4 - there is actually a bug that would
raise the same error.
810026 (http://support.microsoft.com/kb/810026/) FIX: A DELETE statement
with a self-join may fail and you receive a 625 error
--
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:3D1EACAB-CB1B-477B-BA0A-A40B50887D98@.microsoft.com...
> how we know this is from which table or which index?
> 35:1811772
> is that possible know from dbcc page. and what parameter should i put.
> soonyu
> "oj" wrote:
>> look like you have database corruption. run dbcc checkdb to get the
>> report.
>> it's best if you restore the database from a known good backup. if you do
>> not have a backup, contact ms support to have them walk you through
>> recovering (with some loss of data, more than likely).
>> --
>> -oj
>>
>> "soonyu" <soonyu@.discussions.microsoft.com> wrote in message
>> news:31898E05-D2F6-4E77-A310-0F032255F2E7@.microsoft.com...
>> > We have this in sql error log.
>> > spid 66, Getrow: rowoffset entry 35(0) out of range (pg (0x3:0x1ba53c),
>> > obj
>> > 0x6df7358c, db 11, stat b)
>> > Cannot retrieve row from page (35:1811772) by RID because the slotid
>> > (1699164968) is not valid..
>> > Error: 625, Severity: 20, State: 3
>> >
>> > Any idea.. what to check? or we can ignore it?
>> >
>> > --soonyu
>>