I have a SQL Server 2005 Enterprise (SP3) on a Windows Server 2003 R2 (SP2). I'm not familiar with replication so, please, be nice with me... ;-)
My issue is that I've found (3 differents days) errors with the replication:
Connection: Internet
Replication Monitor Details:
05/17/10 The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)
05/20/10 The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)
05/24/10 A read operation from the Internet returned an incorrect number of bytes. [,,,,,] (Source: MSSQLServer, Error number: 28001)
Beetwen those days I have synchronizations completed successfully.
My questions are:
1. What could be the root cause of the error to avoid it in the future?
2. If I "reinitialize the subscription (without upload)", as the error message says, is there a chance to get thing worst?
3. How can I solve this?
Thanks you all for your help.
