sql server replication: Could not find the index entry for RID -- sql server replication

Could not find the index entry for RID

andrew bourne
11/29/2005 11:00:09 AM

sql server replication: Hi all, got this error and well want some advice really. Cheers

The process could not enumerate changes at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
---------------------------------------------------------------------------------------------------------------
Could not find the index entry for RID
'16f8db910fd437730d2cca409ba472f23ca363ef200' in index page (1:353425),
index ID 0, database 'VMR'.
(Source: BBSERVER-SAT1 (Data source); Error number: 644)
---------------------------------------------------------------------------------------------------------------
The merge process encountered an unexpected network error. The connection to
Subscriber 'BBSERVER-SAT1' is no longer available.
(Source: Merge Process (Agent); Error number: -2147199469)
---------------------------------------------------------------------------------------------------------------

Re: Could not find the index entry for RID

Hilary Cotter
11/29/2005 12:15:59 PM

Put the database in single user mode and run a dbcc dbreindex, this normally
solves this problem.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]