merge replication agent error

  • 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