x

Merge Replication Error - Please help.

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.

more ▼

asked May 27, 2010 at 05:21 PM in Default

Janoland gravatar image

Janoland
1 1 1 2

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1945
x305
x47

asked: May 27, 2010 at 05:21 PM

Seen: 2006 times

Last Updated: May 28, 2010 at 02:53 PM