metadata cleanup 2147199401

Hi,
I'm getting the following error on SQL Server 2005
Error messages:
The Merge Agent failed after detecting that retention-based metadata cleanup
has deleted metadata at the Subscriber for changes not yet sent to the
Publisher. You must reinitialize the subscription (without upload). (Source:
MSSQL_REPL, Error number: MSSQL_REPL-2147199401)
Get help: http://help/MSSQL_REPL-2147199401
The subscription has been running fine for several months and re
initialising is painful due to the size of the DB and the connection speed.
Has anyone encountered this error or know of a fix?
Thanks
NW
There seems to be a bug with this that Microsoft is in the process of trying
to fix (from what I understand). I suggest you open a support incident with
Microsoft on this.
http://www.zetainteractive.com - Shift Happens!
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
"NeilWake" <NeilWake@.discussions.microsoft.com> wrote in message
news:A8E78C08-E908-4D41-A03B-A5BE807C7D7C@.microsoft.com...
> Hi,
> I'm getting the following error on SQL Server 2005
> Error messages:
> The Merge Agent failed after detecting that retention-based metadata
> cleanup
> has deleted metadata at the Subscriber for changes not yet sent to the
> Publisher. You must reinitialize the subscription (without upload).
> (Source:
> MSSQL_REPL, Error number: MSSQL_REPL-2147199401)
> Get help: http://help/MSSQL_REPL-2147199401
> The subscription has been running fine for several months and re
> initialising is painful due to the size of the DB and the connection
> speed.
> Has anyone encountered this error or know of a fix?
> Thanks
> NW
>