sql server (alternate): Could not find the index entry for RID... -- sql server (alternate)

Could not find the index entry for RID...

Richard Bailey
5/13/2005 12:00:00 AM

sql server (alternate):

Greetings. Today I was testing the sql backup/restore functions on our
primary server. I was able to backup my database without any problems
but when I tried to restore it, I received an error "Could not find the
index entry for RID '3610200101a03cc4b49d8bbc84bac50cbe042cecf76' in
index page (1:40), index ID 0, database 'walkthrough'." Thinking that
data had been corrupted somehow I tried another database and received a
similar error for that database. In the past, our service provider has
attempted to restore data to this server and the restore failed do to
another data corruption. The problem is, I can't find out where the
corruption is located or how to fix it.

When I open the restored database in enterprise manager, it returns the
above error and is unable to get a listing of my tables. In query
analyzer I am able to view my data but receive the index error when I
attempt to look at the information_schema data. When I try to run a DBCC
CHECKDB on the corrupted database it reports 0 errors and 0
inconsistencies.

So my diagnosis of the problem is that something is corrupting my system
tables and that problem shows up whenever I try to restore data from a
backup. There could be a hardware failure but I believe the failure
would affect more then just the sql system tables. Can anyone offer any
advice on how to find the corruption?

Thank you in advance

Richard Bailey

Re: Could not find the index entry for RID...

John Bell
5/14/2005 12:00:00 AM

Hi

If a DBCC CHECKDB does not help see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23sk.asp
and
http://groups-beta.google.com/group/microsoft.public.sqlserver.server/msg/df5e89b4b56fb232?hl=en
then you may want to call PSS. Also you may want to look for anything in the
event log and run some diagnostics on the disc.This will depend on what sort
of contract you have with the service provider.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_rptconsetup_1s8i.asp
http://support.microsoft.com/default.aspx

John

[quoted text, click to view]