November 18, 2013 at 11:55 am
Hi,
I have a merge replication between 5 servers. Since last weekend, the agent fail for one of the server (located in Florida) with the following error:
The merge process could not perform retention-based meta data cleanup in database 'DB_Prod'.
(Source: Merge Replication Provider (Agent); Error number: -2147199467)
---------------------------------------------------------------------------------------------------------------
Could not continue scan with NOLOCK due to data movement.
(Source: FLOETC (Data source); Error number: 601)
---------------------------------------------------------------------------------------------------------------
The replication with the other servers works fine. And locally in Florida, all operations run smoothly, data are ok in the database.
I ran a DBCC checkDB on the Florida's database:
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 274152072, index ID 1. Parent node for page (1:69360) was not encountered.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 274152072, index ID 1. B-tree chain linkage mismatch. (1:69360)->next = (1:69361), but (1:69361)->Prev = (1:117308).
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 274152072, index ID 1. Parent node for page (1:69361) was not encountered.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 274152072, index ID 1. The previous link (1:69361) on page (1:69362) does not match the previous page (1:135) that the parent (1:161), slot 1 expects for this page.
DBCC results for 'DB_Prod'.
what can I do with that?? any idea how I can fix this problem?
thanks a lot for your time and help
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply