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
*** Sent via Developersdex http://www.developersdex.com ***