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...
>
>|||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...[vbcol=seagreen]
> 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|||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...
>
>|||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...[vbcol=seagreen]
> 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:
>