SQLServerCentral / SQL Server 2005 / Data Corruption / Cannot retrieve row from page (1:2108289) by RID / Latest Posts

RE: Cannot retrieve row from page (1:2108289) by RID

mahesh.dasoni — Wed, 03 Oct 2012 04:46:06 GMT

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.

RE: Cannot retrieve row from page (1:2108289) by RID

Erik Bitemo — Fri, 07 Sep 2007 02:47:00 GMT

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 ).

RE: Cannot retrieve row from page (1:2108289) by RID

Paul Rubel — Thu, 02 Aug 2007 09:44:00 GMT

RESTORE from a clean backup

RE: Cannot retrieve row from page (1:2108289) by RID

DeirdreBachman — Wed, 01 Aug 2007 07:45:00 GMT

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/826433Having 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.

RE: Cannot retrieve row from page (1:2108289) by RID

Nido786 — Tue, 31 Jul 2007 23:15:00 GMT

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 ???????/????

RE: Cannot retrieve row from page (1:2108289) by RID

DeirdreBachman — Tue, 31 Jul 2007 12:39:00 GMT

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)

Cannot retrieve row from page (1:2108289) by RID

Nido786 — Mon, 30 Jul 2007 06:57:00 GMT

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 "

Regadrs

Syed Naveed