Wednesday, March 28, 2012

merge cannot be performed

I have an error in our replication server. The error reads, "The merge
process could not perform retention-based meta data cleanup in Database
"ourdatabasename".
The detail portion of the errors indicates that "The index entry for row ID
WAS NOT FOUND IN INDEX ID 2, of table 421576540 in database
"ourdatabasename".
does anybody know what this is and how we can fix it.
tx
run a DBCC reindex. You may have to drop the subscription to do this.
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
"tlee" <tlee@.lang.com> wrote in message
news:OVOpurdHFHA.3376@.TK2MSFTNGP14.phx.gbl...
> I have an error in our replication server. The error reads, "The merge
> process could not perform retention-based meta data cleanup in Database
> "ourdatabasename".
> The detail portion of the errors indicates that "The index entry for row
ID
> WAS NOT FOUND IN INDEX ID 2, of table 421576540 in database
> "ourdatabasename".
> does anybody know what this is and how we can fix it.
> tx
>
sql

No comments:

Post a Comment