Cannot retrieve row from page (1:2108289) by RID
-
MigrationData is my production database last few days i got the error message when i execute a procedure on this database, although i have installed new service pack 4 for sql server 2000.also i have recreated a new database By script but issue is same could any one help me in this regards
Error "
Server: Msg 625, Level 20, State 3, Procedure sp_TransformAccountAverageBalances, Line 27
Cannot retrieve row from page (1:2108289) by RID because the slotid (1) is not valid.
Connection Broken "
Syed Naveed
-
Since no-one else is answering, I'll take a stab - try running dbcc checkdb (or dbcc checktable with ALL_ERRORMSGS, if you know the specific table that it's complaining about) If you come up with errors, you might even be able to fix them with this command, depending on the severity/type of error (basically, the RID is the internal ID SQL uses to "point" to rows, and I think it's telling you that you've got a RID pointing someplace invalid, the db may just need to clean that pointer up)
-- http://dbachman.blogspot.com
-
i have done it to execute DBCC for database and DBCC for table as per your instruction but there is no change i am facing a same problem what should i do should i reinstall the sql server ???????/????
-
It seems like maybe you have a "lost write" - toward the end of the article it shows your error and gives a small explanation of what happened:
http://support.microsoft.com/kb/826433
Having said that, I can't find any advice on how to deal with an existing "lost write" that you haven't already tried (everyone says just to SP4 the machine, which you've done) However, (and this is just me thinking out loud) if it is a problem with data pointing to unallocated space, you might try dbcc checkalloc and see if this reveals any errors which were not turned up by the checktable and checkdb.
-- http://dbachman.blogspot.com
-
RESTORE from a clean backup
-
Hi,
Just a quick question to avoid a pitfall: Do you use uncommitted read in your query? I yes, this error message can be quite normal (if not pointing to the same page and slot always
).-- Erik http://blog.rollback.hu
-
run the dbcc checktable with repair and rebuild option and with error msg.
this can done the page repare in database.
this will retrive all the data without data loss. i get exact output.
in case you are not identifiable the exact table run dbcc checkdb.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply